Sql

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

##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

PREVIOUS	NEXT

Code Example
Sql :: mysql interval 1 day
Sql :: wordpress database query change url
Sql :: find table from column name in sql
Sql :: how remove column in mysql
Sql :: oracle modify column type
Sql :: delete database mysql
Sql :: delete first row in sql
Sql :: mysql remove last character
Sql :: oracle start job
Sql :: sql last 7 days
Sql :: oracle first day of last year
Sql :: mysql remove unique constraint
Sql :: InnoDB: page_cleaner: 1000ms intended loop took 7742ms. The settings might not be optimal
Sql :: append column sql
Sql :: mysql count words
Sql :: key validation sql
Sql :: copy column data to another column sql with creating slugs
Sql :: mysql date greater than 30 days
Sql :: sql decrement value by 1 if not null or zero
Sql :: ms sql how to see active job current run time
Sql :: Postgres upgrade to superuser
Sql :: mysql get count of rows
Sql :: installing mysql on fedora
Sql :: drop temp table sql
Sql :: oracle check numeric
Sql :: apex select list ORA-20999
Sql :: mysql select from outside
Sql :: set all the vluses in calumn in sql to false
Sql :: sql server loop over query
Sql :: how to get weekday from old date in sql