DATEFROMPARTS() 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 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)
2010-12-31If you have any queries or suggestions, please feel free to ask in comments section.