Viewing 2 posts - 1 through 3 (of 3 total)
I just want to know that in below example.
SELECT * FROM sys.time_zone_info
lets take example of Easter Island Standard Time (-05:00) here the column is_currently_dst...
November 20, 2024 at 6:05 am
#4486349
Always store your datetimes as UTC The DB creates the timestamp in UTC
The when selecting,
SELECT LocalTime = TimeFromtable AT TIME ZONE 'UTC' AT TIME ZONE 'your...
November 20, 2024 at 3:28 am
#4486300