date parsing

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: date parsing
Date: 2003-06-26 08:21:02
Message-ID: 12fa01c33bbb$e2bce820$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2003-06-26 11:19:04 Missing 7.3.3 cvs tag
Previous Message nolan 2003-06-26 07:06:34 Re: Updating psql for features of new FE/BE protocol