/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 vote365 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote335 views1 answer
Sql query for getting data with join and count
SQL
0 vote341 views1 answer
Postgresql print variable
SQL
0 vote364 views1 answer
Close sql query vb.net
SQL
6 votes364 views3 answers
Oracle all dates between two dates
SQL
0 vote356 views1 answer
Sqlite to csv statement
SQL
4 votes361 views1 answer
Wildcard in sql
SQL
0 vote337 views1 answer
Convert sql server guid to varbinary
SQL
4 votes372 views2 answers
Postgresql default value
SQL
1 vote365 views1 answer
Raise application error in oracle
SQL

Share