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

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