Thread: date parsing

date parsing

From
"Christopher Kings-Lynne"
Date:
Is this deliberate?

usa=# select '1-1-2001'::date;   date
------------2001-01-01
(1 row)

usa=# select '1-1--2001'::date;   date
------------2001-01-01
(1 row)

usa=# select '1-1---2001'::date;   date
------------2001-01-01
(1 row)

usa=# select '1------------------1--------------2001'::date;   date
------------2001-01-01
(1 row)


Chris




Re: date parsing

From
Tom Lane
Date:
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Is this deliberate?
> usa=# select '1-1--2001'::date;
> [works]

The guys who might actually be able to tell you whether it was an
intended behavior are long gone.  But I don't see any particular
problem with it.
        regards, tom lane