If you do not specify a value for the optional time zone parameter in certain date and time functions, Event Stream Processor uses Coordinated Universal Time (UTC).
Corresponding functions in Sybase CEP defaulted to the server's local time zone when no parameter was specified. If you are migrating CEP projects that do not have a time zone defined, they will use UTC when converted to Event Stream Processor. To continue using the server’s local time zone, explicitly set that time zone in the time zone parameter for the following functions:
| Sybase CEP Functions | Event Stream Processor Functions |
|---|---|
| dayofmonth | dayofmonth |
| dayofweek | dayofweek |
| dayofyear | dayofyear |
| hour | hour |
| maketimestamp | makebigdatetime |
| microsecond | microsecond |
| minute | minute |
| month | month |
| second | second |
| to_string | to_string |
| year | year |