DATETIMEOFFSETFROMPARTS() function syntax with an example in SQL Server

DATETIMEOFFSETFROMPARTS()function syntax with an example in SQL Server 

·        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.
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar