Returns a datetime value for the specified date and time.
Applies to: SQL Server (SQL Server 2012 through current version), Azure SQL Database.
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 2014 servers and above. It will not be remoted to servers that have a version below SQL Server 2014.