/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 vote155 views1 answer
How to query without duplicate rows in sql
SQL
0 vote144 views3 answers
Remove folders from remote git
SQL
1 vote160 views1 answer
Select not matching data from two tables
SQL
1 vote142 views1 answer
Order by oracle
SQL
0 vote153 views1 answer
Mysql filter based on datediff
SQL
0 vote155 views1 answer
Python connect microsoft sql server
SQL
0 vote174 views1 answer
Time in sql server
SQL
6 votes183 views1 answer
How to get the size of the database in postgresql
SQL
1 vote111 views1 answer
Ms sql - add one hour to time
SQL
9 votes146 views3 answers
Mysql get last id
SQL

Share