Re: Evidently no support for the mmddyyyy date format

2009/4/10  <bfb21@comcast.net>:
> 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" <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
>>
>