DATEFROMPARTS() function syntax with an example in SQL Server

   DATEFROMPARTS() function syntax with an example in SQL Server

·        This function returns a date value with the date part set to the specified year, specified month and the specified day.

·        All the arguments should be valid else error is thrown; if NULL value is in argument then NULL is returned.

                        SELECT DATEFROMPARTS (2010, 12, 31)


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