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...

• This reply was modified 10 months, 2 weeks ago by gauravkumar9.

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...