Re: A creepy story about dates. How to prevent it?

Andrew Snow <andrew@modulus.org>

From: Andrew Snow <andrew@modulus.org>
To: cmarin@dims.com, pgsql-general@postgresql.org
Date: 2003-06-18T22:38:52Z
Lists: 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