Re: Evidently no support for the mmddyyyy date format

[bfb21@xxxxxxxxxxx]

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@xxxxxxxxx>
To: rod@xxxxxx
Cc: "Bernard Barton" <bfb21@xxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
Sent: Friday, April 10, 2009 5:40:21 AM GMT -05:00 US/Canada Eastern
Subject: Re: 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@xxxxxx>:
> 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@xxxxxx
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>