DATETIMEOFFSETFROMPARTS()function syntax with an example in SQL Server
In my previous posts we have seen what is Transact-Sql in sql server and What are new top features of T-Sql in server. This is one of the best sql server interview Questions and answers. Watch more ASP.NET, C#.NET, Jquery, Sql Server, HTML5, HTML, CSS, JQUERY UI Interview questions from here.
· This function returns a datetimeoffset value for the specified date and time and with the specified offsets and precision.
SELECT DATETIMEOFFSETFROMPARTS (2011, 09, 02, 23, 55, 9, 54, 5, 30, 5)
2011-09-02 23:55:09.00054 +05:30
If you have any queries or suggestions, please feel free to ask in comments section.