[AccessD] Time zones (was: internationalization)

No, but after a quick archive search I found it, thanks :D 
thanks Gustav, so to be clear, if I have a record from daylights
savings time, and I query it in NON-Daylights saving time, this code
will keep the record at it's accurate time, meaning

if It was processed in the summer  (GMT-8) at 4pm, and I query the
record in the Winter will the record show up processed at 4pm or 3pm?,
the UTC time stored in the db doesn't change, but when they query it,
will.

Thanks,


On Wed, 1 Sep 2004 18:48:39 +0200, Gustav Brock <gustav at cactus.dk> wrote:
> Hi Francisco
> 
> Well, to Charlotte this seems to be no problem, but it was
> considerations as those you describe I was thinking of.
> 
> So far my thoughts would be to store date/time as UTC time, then do
> the conversion (shift) later to whatever time zone you may need.
> But what is your question really? Daylight savings is just another
> twist to time zone issues. And remember, some time zones are offset by
> 30 or even 15 minutes only.
> 
> Did you see my code previously posted (2004-07-14)?
> 

-- 
-Francisco