Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

CONVERT_TZ mysql

##Syntax: 
##CONVERT_TZ(datetime, from_tz, to_tz)

SELECT CONVERT_TZ('2008-05-15 12:00:00','+00:00','+10:00');
##Output: 2008-05-15 22:00:00
 
PREVIOUS NEXT
Tagged: #mysql
ADD COMMENT
Topic
Name
5+1 =