Re: [HACKERS] date format: Canada same as European or US?

teunis <teunis@mauve.computersupportcentre.com>

From: teunis <teunis@mauve.computersupportcentre.com>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-01-15T22:45:33Z
Lists: pgsql-hackers
On Sun, 4 Jan 1998, The Hermit Hacker wrote:

> 
> Can someone comment on this?  For an SQL server in Canada, should we be using
> European format? *raised eyebrow*  I'm currently using the default (US) format

Yes - Canada follows european dates, spelling, and measurement system.
I guess it's a matter of choice though...  I think how the US spell
"colour" is weird for instance....  and reading their dates is a pain.
(also I prefer tea with a little bit of milk and sugar... haven't a clue
where that's from :)

So how do I setup postgres for Canada?  *curious?*

> ------------------------------------
> 
> > 	mmddyy is proper ISO/SQL format for north america...we went through a major
> > discussion as to the differences, because European dates are *totally* different :(
> 
> Yes canada is supposed to be the same as europe being date/month/year
> as in small > large while americans go month day year which is no
> order at all...
> 

G'day, eh? :)
	- Teunis  ... trying to catch up on ~500 backlogged messages
			here...