/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

3 votes197 views1 answer
Oracle APEX elapsed time
SQL
0 vote238 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
5 votes183 views1 answer
Sql select ciunt
SQL
5 votes185 views1 answer
Postgres integer to serial
SQL
4 votes200 views2 answers
Postgresql default value
SQL
0 vote202 views1 answer
List all indexes postgres
SQL
0 vote285 views2 answers
Search stored procedures by name
SQL
5 votes193 views1 answer
Oracle ORA-00054 origin
SQL
0 vote179 views1 answer
Oracle list index on table
SQL
0 vote252 views1 answer
Sqlite3 pragma foreign keys
SQL

Share