| 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: | Whole Thread | Raw Message | 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 |