15.4 Using Date Functions

The following date functions are supported in this release:

Function Name Description

day(date)

Returns day of the date

eventtimestamp()

Returns event timestamp from stream

hour(date)

Returns hour of the date

minute(date)

Returns minute of the date

month(date)

Returns month of the date

nanosecond(date)

Returns nanosecond of the date

second(date)

Returns second of the date

systimestamp()

Returns the system’s timestamp on which the application is running

timeformat(value1,value2)

Returns the provided timestamp in required time format

year(date)

Returns year of the date