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: