DAY (Azure Stream Analytics)

Returns an integer representing the day (day of the month) of the specified date.

Syntax

DAY ( date )  

Arguments

date

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

Return Types

bigint

Examples

SELECT DAY (EntryTime)  
FROM Input TIMESTAMP BY EntryTime  
WHERE Toll > 5