TODATETIMEOFFSET
returns a datetimeoffset from the specified datetime.
The fractional precision is the same as the datetime value provided.
This example returns a timezoneoffset with +8:00 for the specified date.
SELECT TODATETIMEOFFSET ('2022-09-28 8:54:16', '+08:00')
AS 'Datetime Offset'
Datetime Offset |
---|
2022-09-28 08:54:16.0000000 +08:00 |
Syntax of the TODATETIMEOFFSET function .
TODATETIMEOFFSET(datetime, offset)
datetime
-- a datetime2 value or column name.
offset
-- a timezone offset or signed integer representing from +14 to -14.