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

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.

Well, 03MAR07 is not a valid date. This is the formats we understand:

http://www.postgresql.org/docs/8.2/static/datatype-datetime.html

Joshua D. Drake

> Any ideas?
>
> best regards,
> billc
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/