How are timestamps stored in StreamBase?
Article ID: KB0074459
Updated On:
| Products | Versions |
|---|---|
| TIBCO Streaming | 7 |
Description
How are timestamps stored in StreamBase?
Is there any performance advantage in converting a timestamp field that is a part of a Query Table index into a double using the Expression Language function: to_seconds()?
Resolution
Internally, timestamps are stored as 64 bit integers representing milliseconds from epoch() without timezone data. Converting them to doubles does not improve performance. Fetching a timestamp is just as fast as fetching a double.
Issue/Introduction
How are timestamps stored in StreamBase?
Feedback
Yes
No
Powered by
