Home > SQL SERVER > Converting DateTime to UTCDATETIME and Local DATETIME

Converting DateTime to UTCDATETIME and Local DATETIME


DECLARE @LocalDate DATETIME
SET @LocalDate = GETDATE()

— convert local date to utc date
DECLARE @UTCDate DATETIME
SET @UTCDate = DATEADD(Hour, DATEDIFF(Hour,GETDATE(),GETUTCDATE()), @LocalDate)

— convert utc date to local date
DECLARE @LocalDate2 DATETIME
SET @LocalDate2 = DATEADD(Hour, DATEDIFF(Hour, GETUTCDATE(), GETDATE()), @UTCDate)

SELECT @LocalDate, @UTCDate, @LocalDate2

Advertisements
Categories: SQL SERVER
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: