date parsing
Started by Christopher Kings-Lynneover 22 years ago2 messages
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
"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