Convert timezone to local

Submitted by:Andery Smith

Date added:05 July, 2012

Category:MySQL

Converts a date or time from one timezone to another.

Tags: convert timezone

Code Snippet:

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

Comments