Posted By

fugue on 03/10/10


Tagged

time date timezone


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

dantreacy
jearley
kubaitis
virendrakryadav


Convert timezone to local


 / Published in: MySQL
 

URL: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_convert-tz

Converts a date or time from one timezone to another.

  1. SELECT CONVERT_TZ(mydatefield,'US/Pacific','CET') FROM mytable;

Report this snippet  

You need to login to post a comment.