Esper \ Time functions in the query

Question

I am new in using the esper engine (java) - and I didn't find an answer in their documentation to the following question:

My event object has Date member. what date functions are available in this EPL query language to compare dates (before, after) to calculate the interval between two dates ([ where d1 - d2 > 4 days] etc. )

In short, where are all the date functions to this query langugage?

score 0 · Answer 1 · answered Mar 23 '11 at 15:41

0

Esper currently doesn't itself offer EPL constructs specifically to handle Date/Calendar functions. Its easy however to plug in you own single-row function or static methods to handle. Version 4.2 is planned to have extensive datetime methods.

answered Mar 23 '11 at 15:41

user650839

2,594
1
13
9

thanks for your response. so the easier thing is to convert the date to long and refer it as a number in the query? – Eyal Mar 23 '11 at 17:36

score 0 · Answer 2 · answered Sep 21 '22 at 11:48

The latest version (8.8.0 as of writing this answer) has extensive date / time functions

http://esper.espertech.com/release-8.8.0/reference-esper/html/datetimereference.html

A similar example of after from that page

select * from A#lastevent as a, B#lastevent as b where a.after(b, 5 sec)
// Above matches when:
//   a.startTimestamp - b.endTimestamp >= 5 seconds

Esper \ Time functions in the query

2 Answers2