Thread: Re: NEWBIE: Date format/timestamp issue ?

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.

Neil E.
Remove [removetoreply] from email address to mail me direct

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?