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