3 out of 4 rated this helpful - Rate this topic

DATETIMEFROMPARTS (Transact-SQL)

SQL Server 2012

Returns a datetime value for the specified date and time.

Topic link icon Transact-SQL Syntax Conventions


          

DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds )

Arguments

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.

Return Types

datetime

Remarks

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 2012 servers and above. It will not be remoted to servers that have a version below SQL Server 2012.

Examples

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)

Reference

datetime (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD