DATETIMEFROMPARTS() function syntax with
an example in SQL Server
Introduction:
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.
Description:
·
This function returns a full datetime value for the specified date and time.
·
It is almost similar to the
DateFromParts function with the change that it returns a Date time component.
Example:
SELECT DATETIME2FROMPARTS (2010,
12, 31, 23, 59, 59, 0)
Result:
2010-12-31
23:59:59.000
If you have any queries or suggestions, please feel free to ask in comments section.
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.