Re: Time-Zone juggling

On 11/8/06, tedd <tedd@sperling.com> wrote:

At 12:48 AM -0500 11/8/06, Travis Doherty wrote: This can be a big problem to some apps, and others might be fine with the workaround like we've done where you loose a tiny bit of data (It's 08:00 on the day after the timechange, is this ticket from 01:30:00 6.5 or 7.5 hours old? who cares.. just reply.) and At 9:53 PM -0600 11/7/06, Richard Lynch wrote: This time zone stuff always gets me head all spun around, I admit freely. You're not alone. What about just using what we did in the service, namely Zulu? http://www.grc.nasa.gov/WWW/MAEL/ag/zulu.htm At least that points to a common datum for all time related issues. I just wonder how they came up with the acronym of "UTC" for Coordinated Universal Time? Best, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

tedd, Does Daylight Savings alter Zulu time? (I'm guessing "yes"). How did the military deal with that? I use a date-time field as a primary key in db tables that get an insert a minute. I had to jump through a number of hoops to turn off DST on the (RH Linux) server. David