Penchalaiah P. wrote: > I am using date is data type to one of the field in my table....but when > ever I am passing values to that field it is taking yyy-mm-dd format.. > > But I don't want like that .. I need like this DD-MM-YYYY.. for this wt > I have to do...
Read the documentation on the "DateStyle" parameter, noticing that it controls two things at once, input and output of dates. You may also use to_char() or extract() to format the date manually without messing with the configuration. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly