/SQL/Convert_tz mysql

Convert_tz mysql

Convert_tz mysql

CONVERT_TZ(datetime, from_tz, to_tz)

Example: 
SELECT CONVERT_TZ('2031-09-21 02:42:14', 'UTC', 'America/New_York');
output: 2031-09-20 22:42:14

2

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

0

Similar codes

4 votes263 views2 answers
How to count items with same name in sql
SQL
0 vote272 views2 answers
How to find max and min salary in sql
SQL
2 votes279 views3 answers
Mysql list tables by size
SQL
1 vote282 views1 answer
Oracle apex prevent initial load
SQL
2 votes276 views1 answer
Oracle table size
SQL
0 vote268 views1 answer
Java mysql date format
SQL
1 vote278 views1 answer
Sql server locks
SQL
1 vote302 views1 answer
Mysql check if string contains comma separated
SQL
7 votes336 views1 answer
Buy forge mods server hosting
SQL
1 vote303 views3 answers
What is union in sql
SQL

Share