Datetime input-parsing shortcoming

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Datetime input-parsing shortcoming
Date: 1999-02-09 01:34:52
Message-ID: 1163.918524092@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Seen with current sources and with 6.4.2:

When datestyle = 'Postgres,European', the datetime parser will accept
dates written in either US or Euro order:

regression=> set datestyle = 'Postgres,European';
SET VARIABLE
regression=> select 'Wed 06 Jan 16:10:00 1999 EST'::datetime;
?column?
----------------------------
Wed 06 Jan 16:10:00 1999 EST
(1 row)

regression=> select 'Wed Jan 06 16:10:00 1999 EST'::datetime;
?column?
----------------------------
Wed 06 Jan 16:10:00 1999 EST
(1 row)

But when datestyle = 'Postgres,US' it won't:

regression=> set datestyle = 'Postgres,US';
SET VARIABLE
regression=> select 'Wed Jan 06 16:10:00 1999 EST'::datetime;
?column?
----------------------------
Wed Jan 06 16:10:00 1999 EST
(1 row)
regression=> select 'Wed 06 Jan 16:10:00 1999 EST'::datetime;
ERROR: Bad datetime external representation 'Wed 06 Jan 16:10:00 1999 EST'

A bug, no??

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Parker Henderson 1999-02-09 01:57:03 How do I unsubscribe?
Previous Message Tom Lane 1999-02-09 00:02:22 Re: [HACKERS] samekeys