2009/4/10 <[email protected]>: > 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. >
other solution is custom datatype. It isn't too much work, but it is coding in C. regards Pavel Stehule > -Thanks > > > > ----- Original Message ----- > From: "Pavel Stehule" <[email protected]> > To: [email protected] > Cc: "Bernard Barton" <[email protected]>, [email protected] > 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 <[email protected]>: >> 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 >> [email protected] >> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals >> ------------------------------------------------------------------ >> >> -- >> Sent via pgsql-general mailing list ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
