DATETIME2FROMPARTS() function syntax with an example in SQL Server

DATETIME2FROMPARTS()function syntax with an example in SQL Server 

·        This function returns a datetime2 value for the specified date and time and with the specified precision.

·        This function is almost identical to DateTimeFromParts function except that it returns a datetime2 value

            SELECT DATETIME2FROMPARTS (2010, 12, 31, 23, 59, 59, 0, 0)

            2010-12-31 23:59:59.0000000

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