Sql

Search

sql server utc to local

SELECT
	['TIME COLUM TO CONVERT'] AS [UTC_TIME],
	DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()),['TIME COLUM TO CONVERT']) AS [lOCAL_TIME]
FROM ['TABLE NAME']

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql remove first character from string
Sql :: mac os zsh: command not found: mysql
Sql :: oracle export trigger ddl
Sql :: sql change password wordpress
Sql :: create procedure with encryption
Sql :: copy sql table
Sql :: set boolean flasksql
Sql :: sql server alter table add column datetime default current_timestamp
Sql :: apex ORA-20999
Sql :: sql for date greater than
Sql :: sql select column names
Sql :: sql server roles and users
Sql :: oracle split string
Sql :: sql primary key with multiple columns
Sql :: search query in mysql
Sql :: return sql query laravel
Sql :: update select
Sql :: mysql default port
Sql :: update set with inner join oracle
Sql :: psql import backup file for windows
Sql :: mysql shell ERROR: Not connected.
Sql :: mariadb number format
Sql :: mysql root localhost run
Sql :: psql: FATAL: Ident authentication failed for user "postgres"
Sql :: mysql persistence.xml
Sql :: where to locate set password for mysql
Sql :: alter table name
Sql :: sql update all rows
Sql :: mysql docker
Sql :: how to search date in sql query

Search

SQL

sql server utc to local

ADD CONTENT