Skip to content

Latest commit

 

History

History
40 lines (27 loc) · 838 Bytes

datetimefromparts-azure-stream-analytics.md

File metadata and controls

40 lines (27 loc) · 838 Bytes
Raw
title description applies_to ms.service ms.topic ms.date
DATETIMEFROMPARTS (Azure Stream Analytics)
Returns a datetime value for the specified date and time.
Azure
stream-analytics
reference
04/22/2016

DATETIMEFROMPARTS (Azure Stream Analytics)

Returns a datetime value for the specified date and time.

Syntax

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

Arguments

date

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

Return Types

datetime

Examples

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