Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Andrew Snow
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id 3EF0E9FC.9090201@modulus.org
Whole thread Raw
In response to A creepy story about dates. How to prevent it?  (Conxita Marín <comarin@telefonica.net>)
Responses Re: A creepy story about dates. How to prevent it?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
This is an old postgres "gotcha" that I've lived with since a long, long
time ago.  It forced me to always use the datestyle YYYY-MM-DD so there
is never any confusion in my programming.

I then convert the date to whatever the current user preference is, at
the application level or with an SQL query call to to_char().

I suggest that this is a good practice to follow.

- Andrew


pgsql-general by date:

Previous
From: Travis Hume
Date:
Subject: Re: can't "grant all on database..."
Next
From: Paul Thomas
Date:
Subject: Re: A creepy story about dates. How to prevent it?