/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

58 votes540 views6 answers
Create new user in postgres
SQL
0 vote192 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote176 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote181 views1 answer
Pl sql join 3 tables
SQL
11 votes171 views2 answers
Insert date sql
SQL
0 vote177 views1 answer
Get last three characters in mysql column
SQL
4 votes181 views2 answers
Oracle default date format
SQL
0 vote193 views1 answer
Reset keys in sql
SQL
0 vote177 views1 answer
Ffeathers express mysql application users login
SQL
0 vote284 views1 answer
Get statis values sql
SQL

Share