I have a timestamp stored in a datetime field. It gets set using Now() when the record was inserted. I would like to pull the data back out and have it in UTC time. Is there an easy way to do this? I've been through the manual and on google but haven't come up with anything. This is in a PHP script I'd like other people to be able to use, so I'd like it to easily run on any MySQL 4.1.x system. Maybe it would just be easiest if I did the UTC conversion in PHP? The only other thing I was thinking of is getting the difference between the regular time and UTC_TIME and then add that to the field value.
-Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]