Re: NEWBIE: Date format/timestamp issue ? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: NEWBIE: Date format/timestamp issue ?
Date
Msg-id 20020314093839.A3439@svana.org
Whole thread Raw
In response to Re: NEWBIE: Date format/timestamp issue ?  (news@gemini-it.postgresql.org, [removetoreply].com@postgresql.org (Neil Everton))
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Newbie: Copy from and dates
Next
From: Tom Lane
Date:
Subject: Re: Looking for information about rtree index