DATEFROMPARTS (TSQL Function)
Returns a date created from the specified year, month, day.
Syntax
DATEFROMPARTS ( year, month , day )
Arguments
- year
- is an expression of type
int
. - month
- is an expression of type
int
. - day
- is an expression of type
int
.
Return Types
Returns date
.
Examples
PRINT DATEFROMPARTS(2016, 07, 31);
The result is:
2016-07-31