| title | DATETIMEFROMPARTS (Transact-SQL) | ||
|---|---|---|---|
| description | DATETIMEFROMPARTS returns a datetime value for the specified date and time arguments. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 05/21/2024 | ||
| ms.service | sql | ||
| ms.subservice | t-sql | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb]
This function returns a datetime value for the specified date and time arguments. For more information about valid ranges, see datetime.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DATETIMEFROMPARTS ( year , month , day , hour , minute , seconds , milliseconds )
An integer expression that specifies a year.
An integer expression that specifies a month.
An integer expression that specifies a day.
An integer expression that specifies hours.
An integer expression that specifies minutes.
An integer expression that specifies seconds.
An integer expression that specifies milliseconds.
datetime
DATETIMEFROMPARTS returns a fully initialized datetime value. DATETIMEFROMPARTS raises an error if at least one required argument has an invalid value. DATETIMEFROMPARTS returns NULL if at least one required argument has a NULL value.
This function is capable of being remoted to [!INCLUDE sssql11-md] servers and later versions. It isn't remoted to servers running [!INCLUDE sssql11-md] and earlier versions.
SELECT DATETIMEFROMPARTS ( 2010, 12, 31, 23, 59, 59, 0 ) AS Result;[!INCLUDE ssResult]
2010-12-31 23:59:59.000