/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

0 vote125 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote109 views1 answer
Oracle string length
SQL
7 votes104 views1 answer
Sql server convert string to date
SQL
0 vote109 views1 answer
Sql where part of string match
SQL
1 vote105 views1 answer
User privileges postgresql information_schema
SQL
0 vote118 views1 answer
How to reset the database value in SQL server
SQL
-1 vote114 views1 answer
Sql show custom constraints
SQL
0 vote55 views1 answer
FindAllBy
SQL
0 vote116 views1 answer
Sql server on mac m1
SQL
0 vote115 views1 answer
Postgresql in vs any performance
SQL

Share