DATETIMEFROMPARTS (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Returns a datetime value for the specified date and time.

Syntax

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

date

Is an expression that can be resolved to a datetime. date can be an expression, column expression, or string literal.

datetime

SELECT EntryTime, DATETIMEFROMPARTS(2014,9,10,12,DATEPART(minute,EntryTime)+10,00,00)   
AS ExitTime  
FROM Input TIMESTAMP BY EntryTime  
WHERE Toll > 5  
  

Show: