Yes, I mentioned that I could use the to_date function, but as I said, that would involve a LOT of changes to a LOT of source code, which I'm trying to avoid.
-Thanks
----- Original Message -----
From: "Pavel Stehule" <pavel.stehule@gmail.com>
To: rod@iol.ie
Cc: "Bernard Barton" <bfb21@comcast.net>, pgsql-general@postgresql.org
Sent: Friday, April 10, 2009 5:40:21 AM GMT -05:00 US/Canada Eastern
Subject: Re: [GENERAL] Evidently no support for the mmddyyyy date format
Hello
use to_date function, please.
postgres=# select to_date('10122008','DDMMYYYY');
to_date
------------
2008-12-10
(1 row)
Time: 1,152 ms
postgres=#
regards
Pavel Stehule
2009/4/10 Raymond O'Donnell <rod@iol.ie>:
> On 09/04/2009 23:56, Bernard Barton wrote:
>> Today I tried every permutation of the DateStyle parameter I could find, and
>> still cannot get PostgreSQL 8.3 to accept dates in the format mmddyyyy. I tried
>
> How exactly are you sending these values to the database? Straight SQL,
> or some other mechanism? Can you show us some examples?
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
