Re: NEWBIE: Date format/timestamp issue ?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: NEWBIE: Date format/timestamp issue ?
Дата
Msg-id 20020314093839.A3439@svana.org
обсуждение исходный текст
Ответ на Re: NEWBIE: Date format/timestamp issue ?  (news@gemini-it.postgresql.org, [removetoreply].com@postgresql.org (Neil Everton))
Список pgsql-general
On Thu, Mar 07, 2002 at 12:46:03PM +0000, news@gemini-it.postgresql.org wrote:
> Hi,
>     I know it's bad form to reply to your own post, but here goes.
>
>     I've fixed the problem (hopefully) it appears that I need to
> add them into the database in mm-dd-yyyy format and then everything is
> OK.

I solved it a different way. I did:

SET DATESTYLE ISO;

And then enter everything as yyyy-mm-dd. Totally unambiguous and works every
times.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> 11/9/2001 - a new beginning or the beginning of the end?

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Newbie: Copy from and dates
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Looking for information about rtree index