Re: Date not being parsed as expected

On Fri, 2002-09-06 at 09:33, Jean-Christian Imbeault wrote:
> Uh? I thought DateStyle could only be ISO, US, or European? Are you
> asking me to set it to ISO AND European?

DateStyle ISO/European means output in ISO and accept input in European
format.

bray=# set DateStyle= ISO,European;
SET VARIABLE
bray=# select '9/10/02'::date;
date
------------
2002-10-09
(1 row)

bray=# set DateStyle= ISO,US;
SET VARIABLE
bray=# select '9/10/02'::date;
date
------------
2002-09-10
(1 row)

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Behold, I stand at the door, and knock; if any man
hear my voice, and open the door, I will come in to
him, and will sup with him, and he with me."
Revelation 3:20