DATEFROMPARTS Date Function TSQL Tutorial

Datefromparts is an date function and returns a date value for the specified year, month or day.

DATEFROMPARTS Syntax:

DATEFROMPARTS ( year, month, day )

DATEFROMPARTS Example:

SELECT DATEFROMPARTS ( 2014, 02, 22 ) AS Date;

Date
2014-02-22