Hi Oliver, > I would like to obtain the time in GMT in mySQL. > > CURRENT_TIMESTAMP returns the local time > SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on > my system > > But how can I get the time in GMT???
MySQL is time-neutral, that is to say, if you ask it the time, it will ask the server OpSys. As my mother used to say, "you only get out of something, what you put into it"! If you declare a date/time column, any data you INSERT will have the same value when you subsequently SELECT it. It's up to you to determine which time zone to use when representing your data. Are you accessing MySQL from some other facility, eg PHP? Can you use that tool to acquire/restate the temporal data? Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
