/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

8 votes178 views1 answer
How to check mysql version in xampp
SQL
0 vote168 views2 answers
Postgres default user
SQL
0 vote178 views2 answers
How to delete the rows with null values in mysql
SQL
2 votes164 views1 answer
Scaffold npgsql net core
SQL
1 vote163 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote210 views1 answer
Display all node label neo4j
SQL
0 vote213 views1 answer
What is default mysql database password in linux
SQL
0 vote173 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote195 views1 answer
Sql max of two values
SQL
1 vote195 views5 answers
What is in operator in sql
SQL

Share