Return
-
Title
User is unable to convert UTC date to local time -
Description
When trying to convert UTC timestamp to Central, Toad's data grid is not displaying the correct time. It adds the "us/central" at end but does not convert the time difference.
Sample:
SELECT
sysID,
createDate1,
(FROM_TZ (createDate1, 'UTC') AT TIME ZONE 'US/CENTRAL') AS localDate
FROM Table1This returns in the data grid (incorrect)...
SYSID LOCALTIME ORIGINALTIME 24828050 1/1/2015 01:00:00.0000 PM US/Central 1/1/2015 01:00:00.0000 PM When expecting (correct)...
SYSID LOCALTIME ORIGINALTIME 24828050 1/1/2015 07:00:00.0000 PM US/Central 1/1/2015 01:00:00.0000 PM -
Cause
This is an issue with the client used. Using direct connect without a client will give incorrect time, and not convert properly. -
Resolution
Install and connect via Full or Instant Oracle client to get proper time conversion.