Re: Dates in inserts

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Dates in inserts
Дата
Msg-id 20030401130025.GA13578@svana.org
обсуждение исходный текст
Ответ на Dates in inserts  ("Michal Kalanski" <kalanskim@zetokatowice.pl>)
Список pgsql-general
On Tue, Apr 01, 2003 at 02:56:36PM +0200, Michal Kalanski wrote:
> insert into dates values('13.01.03');
> insert into dates values('01.13.03');

>         date
> ---------------------
>  2003-01-13 00:00:00
>  2003-01-13 00:00:00
> (2 rows)

Looks like the server is confused about the date format you want to use.
Decide on European or US and do a SET DATESTYLE as appropriate.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Michal Kalanski"
Дата:
Сообщение: Dates in inserts
Следующее
От: "Michal Kalanski"
Дата:
Сообщение: Re: Dates in inserts