Re: NEWBIE: Date format/timestamp issue ?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: news(at)gemini-it(dot)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: NEWBIE: Date format/timestamp issue ?
Date: 2002-03-13 22:38:39
Message-ID: 20020314093839.A3439@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 07, 2002 at 12:46:03PM +0000, news(at)gemini-it(dot)postgresql(dot)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(at)svana(dot)org>
http://svana.org/kleptog/
> 11/9/2001 - a new beginning or the beginning of the end?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-03-13 22:43:29 Re: Newbie: Copy from and dates
Previous Message bombadil 2002-03-13 22:31:03 Re: Referential integrity violation