RE: Time Zones

The only issue with this is if the system timezone changes after timestamps
are stored (CST/DST comes to mind). Ideally the UTC offset as of that
timestamp would be part of the date data. See the email timestamp format:
Mon, 10 Oct 2005 12:49:07 -0400. A variation could extend the ISO format:
2005-10-10.12.49.07.000000.-0400. 

Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta

Seems to me there should be an agreed-upon "standard" for database
times, Rob, and GMT is as good as any.  How the system shows that time
should be a switch on the job, no different than showing the date in
MM/DD/YY or DD-MM-YY.

> From: rob@xxxxxxxxx
> 
> Which brings up an interesting point...
> If I record a timestamp in a file will it store it in UTC?  If someone
> else queries that file (if/when i5/os supports this) will they see the
> timestamp in their timezone?