MSSQL›Date/Time Functions›DATEFROMPARTS
←YEAR

DATEFROMPARTSDate/Time Functions

EOMONTH→

Creates a DATE from year, month, and day.

Syntax

DATEFROMPARTS(y, m, d)

Example

Enter values below to update the example in real time.

christmas→
SELECT DATEFROMPARTS(2024, 12, 25) AS christmas;