 |
 |
 |
 |
|
|
|
Comments for: ehresman20030911
| Message # 1018836: |
|
Date: 02/10/04 00:13
By: Peter Matuchniak Profile Subject: Correction - I think GMT time storage is ok! Mr. Rain wrote: "...Contrary to Mr Matuchniak's comment, storing info in GMT times would prevent data from becoming useless since there would always be a common reference point..." Just to be clear on this point, I never meant to imply that storage in GMT was a bad idea -- au contraire! I think if you are to store the date in only one time zone, then this is THE one to use. The problem that *may* arise is when you wish to display the time in another timezone (such as the user's local time zone and/or in the timezone in which the event occurred). A well-defined routine should handle this offset, but that's assuming it is well-defined (which nowadays is less of an issue, especially if you use something reliable like Oracle or IBM DB2 for this purpose). However, if you ALSO store the time in the local timezone of the event in ADDITION to GMT, then that's one less thing to worry about. Note that I do not personally like storing or using a basic offset -- this is too simplistic and does not take into account Daylight Savings Time (which is not observed by all parts of the world, not even throughout the USA even) and the date is takes effect varies from country to country and year to year. So to conclude: I think GMT is the best general purpose timezone, but I do think a local timezone of the event (along with an indicator that relates to that timezone rather than any offset) has added benefits. |
Previous Message | Next Message |
| Comments: | ||
| RE: Is ther something wrong with this method? | Jason | 12/01/05 19:23 |
| cofiguring iis | sujamary | 09/17/05 13:22 |
| I hate timezones.... | Ryan | 02/27/05 05:36 |
| Suneel Kanuri method beats all! | Marius Ooms | 07/30/04 13:24 |
| RE: A better way to go.. | Olav Alexander Mjelde | 07/07/04 05:30 |
| A better way to go.. | Olav Alexander Mjelde | 04/09/04 15:30 |
| RE: Well Done | Olav Alexander Mjelde | 03/18/04 17:58 |
| Correction - I think GMT time storage is ok! | Peter Matuchniak | 02/10/04 00:13 |
| RE: Here is something i did with my timezones | Vinutha | 02/07/04 04:33 |
| Good Article | Roger Rain | 01/11/04 06:56 |
| Here is something i did with my timezones | Suneel Kanuri | 11/25/03 10:53 |
| TimeZone definition in Environment | Nikola Savic | 10/07/03 05:53 |
| It's much easier if you're on *nix... | Jonathan | 09/22/03 16:42 |
| Sometimes it's easier to store both... | Peter Matuchniak, B.Sc (Maths) | 09/12/03 17:32 |
| Well Done | Paul | 09/12/03 10:51 |
|
If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly. | ||
