Sql

Search

mysql utc to local time

-- using named time zones
SELECT CONVERT_TZ('2018-01-01 12:00:00','UTC','MET');

-- using offset time zones
SELECT CONVERT_TZ('2018-01-01 12:00:00','+00:00','+10:00');

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql find duplicates
Sql :: postgres week number
Sql :: mysql wont stop
Sql :: nosql vs sql
Sql :: sequence postgresql
Sql :: how to select random rows from a table
Sql :: sql get duplicates by composite
Sql :: sql joins
Sql :: pl sql
Sql :: athena create table
Sql :: sql remove duplicates
Sql :: how to write lowercase in sql
Sql :: postgres role does not exist
Sql :: sql delete duplicate rows
Sql :: get largest number in database sql
Sql :: count occurrences sql
Sql :: sql use not in
Sql :: oracle dynamic select into
Sql :: mongodb vs mysql
Sql :: postgres create database if not exists
Sql :: get locked tables sql server
Sql :: select all tables linked server sql
Sql :: what is intersect in sql
Sql :: soql user profile
Sql :: how to get parent and child record in single query using sql
Sql :: difference between normalization and denormalization
Sql :: on update current_timestamp jpa
Sql :: sql server: how to concatenate column data using comma
Sql :: relation does not exist postgresql
Sql :: mariadb case switch

Search

SQL

mysql utc to local time

ADD CONTENT