I have two columns on my table @dateTimeColumn datetime and @timezoneOffsetColumn bigint.
I need to convert these two columns into one column of type datetimeoffset. How can I do it in SQL Server?
@timezoneOffsetColumn is in format: DateTime.Ticks.
| dateTimeColumn | timeZoneOffsetColumn | dateTimeWithTimeZoneColumn |
|---|---|---|
| 2024-09-10 21:00:00.000 | 108000000000 | 2024-09-10 21:00:00.000 +03:00 |
I know this method:
UPDATE @myTable
SET @dateTimeWithTimeZoneColumn = CONVERT(datetime2, @dateTimeColumn) AT TIME ZONE 'Pacific Standard Time'
but I don’t understand how to make it work with my offset
6
Okay, thank you. It works.
UPDATE @myTable
SET @dateTimeWithTimeZoneColumn = TODATETIMEOFFSET(@dateTimeColumn, @timeZoneOffsetColumn / 600000000)
4