/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

1 vote180 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote192 views1 answer
Sql set auto increment back to 0
SQL
9 votes178 views1 answer
Alter table column change data type to text mysql
SQL
1 vote175 views1 answer
Oracle drop chain step
SQL
0 vote186 views1 answer
Sql filter rows with condition
SQL
0 vote173 views1 answer
Oracle call a function in a insert statement
SQL
0 vote159 views1 answer
Check sql database table lock
SQL
7 votes176 views6 answers
Nth highest salary in sql
SQL
0 vote174 views1 answer
Mysql command line ubuntu
SQL
3 votes188 views1 answer
Sql add two values together
SQL

Share