Re: to get DD-MM-YYYY format of data

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.