|
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?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
