Problem
Values in the database are stored as UTC date and time in a simple datetime format. You want to see data time values in the local time.
Solution
Use the following code to convert UTC date/time to local:
CREATE TABLE #table (date_UTC datetime)
/* Populate with UTC date time */
Insert#table Select GETUTCDATE()
Select
/* UTC value */
date_UTC
/* convert UTC to local time */
,DATEADD(MILLISECOND,DATEDIFF(MILLISECOND,getutcdate(),GETDATE()),date_UTC) as date_In_LocalTime
From
table