Search Postgresql Archives

How Can I set a non standard date format?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

best regards,
billc



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux