On 2 Mar 2007 11:20:28 -0800, clark@xxxxxxxxxxxxx <clark@xxxxxxxxxxxxx> wrote:
Hi All Esteemed Developers, I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 I want to be able to have dates returned from a query in this format so that I can use passthrough queries from Access. I know I can use to_char to format the date anyway I want, but this causes the column to appear as a text datatype instead of a date datatype. I am exporting the data to Excel, and the columns that have dates formatted as text do not sort properly. That is why I want the column to remain a date type. In Oracle I could use NLS_TIMESTAMP_FORMAT to accomplish this. But I cannot find a way to use PGDATESTYLE or anything else to to the same thing. Any ideas?
http://www.postgresql.org/docs/8.2/interactive/ecpg-pgtypes.html PGTYPESdate_fmt_asc Best of luck.
best regards, billc
Cheers, Andrej
