Re: How Can I set a non standard date format?

On 2 Mar 2007 11:20:28 -0800, clark(at)knowideas(dot)com <clark(at)knowideas(dot)com> 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