/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 vote204 views1 answer
Postgres enumerated type
SQL
0 vote161 views1 answer
Deleted table in sql trigger
SQL
1 vote211 views1 answer
Drush sql-dump
SQL
9 votes194 views4 answers
Add primary key to existing table sql
SQL
1 vote205 views1 answer
Postgres set column equal to another
SQL
-1 vote164 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote206 views1 answer
Mysql error 1251
SQL
11 votes209 views3 answers
Change column name sql server management studio
SQL
0 vote196 views1 answer
How to find unique key in sql
SQL
7 votes209 views3 answers
Select latest entry in sql table
SQL

Share