SQL Server tutorial for beginners - DATEFROMPARTS function in SQL Server

datefromparts in sql server datetimefromparts sql 2012 smalldatetimefromparts sql server In this video we will discuss DATEFROMPARTS function in SQL Server Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 DATEFROMPARTS function Introduced in SQL Server 2012 Returns a date value for the specified year, month, and day The data type of all the 3 parameters (year, month, and day) is integer If invalid argument values are specified, the function returns an error If any of the arguments are NULL, the function returns null Syntax : DATEFROMPARTS ( year, month, day ) Example : All the function arguments have valid values, so DATEFROMPARTS returns the expected date SELECT DATEFROMPARTS ( 2015, 10, 25) AS [Date] Example : Invalid value specified for month parameter, so the function returns an error SELECT DATEFROMPARTS ( 2015, 15, 25) AS [Date] Output : Cannot construct data type date, some of the arguments have values which are not valid. Example : NULL specified for month parameter, so the function returns NULL. SELECT DATEFROMPARTS ( 2015, NULL, 25) AS [Date] Other new date and time functions introduced in SQL Server 2012 EOMONTH (Discussed in Part 125 of SQL Server tutorial) DATETIMEFROMPARTS : Returns DateTime Syntax : DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds ) SMALLDATETIMEFROMPARTS : Returns SmallDateTime Syntax : SMALLDATETIMEFROMPARTS ( year, month, day, hour, minute ) TIMEFROMPARTS DATETIME2FROMPARTS DATETIMEOFFSETFROMPARTS In our next video we will discuss the difference between DateTime and SmallDateTime. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/datefromparts-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/datefromparts-function-in-sql-server_18.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists