Data types allowed as Timestamp

Challenge

Which data types are supported as the date/time column in the stream query?

Solution

When creating a stream query, Anodot supports the following data types in the timestamp field:

• DATA
• TIMESTAMP
• INTEGER
• BIGINT

This means the relevant database's date/time fields as well as numeric fields of type INTEGER or BIGINT which usually hold time information in epoch format.