Date & time functions - new T-SQL features in SQL Server 2012

Date & time functions - new T-SQL features in SQL Server 2012  

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: Below are new functions for date and time in sql server. Please go through one by one. 

                                         i.    DATEFROMPARTS ()

                                        ii.    DATETIMEFROMPARTS()

                                       iii.    DATETIME2FROMPARTS()

                                      iv.    DATETIMEOFFSETFROMPARTS ()

                                       v.    SMALLDATETIMEFROMPARTS()

                                      vi.    TIMEFROMPARTS()

                                     vii.    EOMONTH()

If you have any queries or suggestions, please feel free to ask in comments section.