/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

-1 vote306 views2 answers
Postgresql get last 10 records
SQL
0 vote332 views1 answer
C# sql transaction multiple connections
SQL
0 vote282 views1 answer
How to find unique key in sql
SQL
0 vote286 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote303 views1 answer
WHERE not regex in SQL
SQL
0 vote297 views1 answer
Sql server list user permissions
SQL
0 vote317 views1 answer
Update top 100 order by sql server
SQL
0 vote241 views1 answer
Finish transaction sql
SQL
3 votes282 views2 answers
How to View column names of a table in SQL
SQL
7 votes314 views3 answers
Sql set
SQL

Share