[thelist] The Sequel: Dates, ASP and mental health
Nicole Parrot
nicole at parrot.ca
Tue Apr 3 11:45:56 CDT 2001
(2 answers in one)
----- Original Message -----
From: "Scott Dexter" <sgd at ti3.com>
> if you have control over the servers themselves, set the local settings on
> the English box to show dates in dd/mm/yy:
Unfortunately I only have control over the French box. And it's not much
control since by LAW it has to be set to French. :(
The English box is in Miami, and is a regular ISP server. I doubt they'd
change it for me.
----- Original Message -----
From: "s t e f" <stef at nota-bene.org>
> I guess the solution is to extract the date from the DB and *THEN ONLY*
> format it locally, through a function of your own. I know it's slower than
> letting the DB do the job, but in this case it's slightly unavoidable, I
> suppose.
But you get screwed if you plan on using SQL to do your date queries.
BTW, I had a similar problem while creating a site for Australia, where they
handle dates meaningfully (dd/mm/yy) :) The site runs on a US server,
which I don't control, and spews out US dates.
Why isn't there a bunch of utility functions that will let us choose the
locale at the code level, and not the OS level?
More information about the thelist
mailing list