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
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 |