From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: to get DD-MM-YYYY format of data |
Date: | 2006-08-22 13:27:05 |
Message-ID: | 20060822132705.GL14368@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-08-22 13:27:36 | Re: to get DD-MM-YYYY format of data |
Previous Message | Penchalaiah P. | 2006-08-22 13:16:11 | to get DD-MM-YYYY format of data |