| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DATETIMEFROMPARTS (Transact-SQL) |
DATETIMEFROMPARTS returns a datetime value for the specified date and time arguments. |
markingmyname |
maghan |
randolphwest |
05/21/2024 |
sql |
t-sql |
reference |
|
|
|
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current |
[!INCLUDE sql-asdb-asdbmi-asa-pdw]
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