SQL TODATETIMEOFFSET function is one of the Date and Time Function, which is used to return a datetimeoffset value from the users specified datetime2, and time zone. In this article we will show you, How to use the SQL Server TODATETIMEOFFSET function with practical example.
SQL TODATETIMEOFFSET Syntax
This function returns datetimeoffset data type value as output. The basic syntax of the TODATETIMEOFFSET Function in SQL Server is as follows:
|
1 |
TODATETIMEOFFSET (datetime2(or Expression), time_zone) |
You can use Hours such as +13.00, -12.00, or Minutes like 120, 240 as the time_zone
SQL TODATETIMEOFFSET Function Example 1
In this example, we will show you the use of SQL Server ToDateTimeOffset function
|
1 2 3 4 5 6 7 8 9 10 11 12 |
-- Example for SQL Server TODATETIMEOFFSET Function SELECT GETDATE() AS Today -- Change Time Zone using Hours SELECT TODATETIMEOFFSET (GETDATE(), '-06:00') AS Result SELECT TODATETIMEOFFSET (GETDATE(), '+05:30') AS Result -- Changing Time Zone using Minutes SELECT TODATETIMEOFFSET (GETDATE(), -150) AS Result SELECT TODATETIMEOFFSET (GETDATE(), 240) AS Result |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply