Re: Date not being parsed as expected
От | Oliver Elphick |
---|---|
Тема | Re: Date not being parsed as expected |
Дата | |
Msg-id | 1031305572.967.13.camel@linda обсуждение исходный текст |
Ответ на | Re: Date not being parsed as expected (Jean-Christian Imbeault <jc@mega-bucks.co.jp>) |
Список | pgsql-general |
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.Elphick@lfix.co.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
В списке pgsql-general по дате отправления: