On 2 Dec 2003 at 9:12, Ron McKeever wrote: > Thats seems like a bug to me. > > I would think FROM_UNIXTIME would take a unixtime stamp > and covert it to what it is. We know its from GMT
A Unix timestamp represents a particular second in time. It doesn't have a time zone associated with it. Yes, the definition of 0 time is based on GMT, but you could just as well say it's the number of seconds since 7 pm on 31 Dec 1969 Eastern Standard Time. The number would be the same. You can represent the time in whatever zone you like; it doesn't change what time you're talking about. DATETIME columns in MySQL are in the local time zone. It wouldn't make sense to convert to a GMT DATETIME, at least not by default. MySQL's handling of time zones leaves something to be desired, but given the way it works the behavior of FROM_UNIXTIME() makes perfect sense. It's not a bug. Avoiding time zone and daylight time issues is the main reason to use Unix time. I don't see the advantage of keeping your time in two different formats. It seems like sticking to one would be simpler. But then I don't know your system. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
