DATETIMEFROMPARTS (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2012)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns a datetime value for the specified date and time.

Topic link icon Transact-SQL Syntax Conventions

-- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse  
  
DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds )  

year
Integer expression specifying a year.

month
Integer expression specifying a month.

day
Integer expression specifying a day.

hour
Integer expression specifying hours.

minute
Integer expression specifying minutes.

seconds
Integer expression specifying seconds.

milliseconds
Integer expression specifying milliseconds.

datetime

DATETIMEFROMPARTS returns a fully initialized datetime value. If the arguments are not valid, then an error is raised. If required arguments are null, then a null is returned.

This function is capable of being remoted to SQL Server 2016 servers and above. It will not be remoted to servers that have a version below SQL Server 2016.

SELECT DATETIMEFROMPARTS ( 2010, 12, 31, 23, 59, 59, 0 ) AS Result;  

Here is the result set.

Result  
---------------------------  
2010-12-31 23:59:59.000  
  
(1 row(s) affected)  

SELECT DATETIMEFROMPARTS ( 2010, 12, 31, 23, 59, 59, 0 ) AS Result;  

Here is the result set.

Result  
---------------------------  
2010-12-31 23:59:59.000  
  
(1 row(s) affected)  

datetime (Transact-SQL)

Community Additions

ADD
Show: