How to define a time-of-day query range that is date-agnostic
Article ID: KB0074915
Updated On:
| Products | Versions |
|---|---|
| TIBCO Streaming | - |
Description
How can I define a time-of-day range for LiveView queries that is date-agnostic? For example, I'd like to add a condition where I want to select all rows where the value of field ArrivalTime is between 9am and 11am on ANY day.
Resolution
To select rows between two hours of the day use the ArrivalTime timestamp field with the following predicate expression:
To select rows between two arbitrary times, 9:30am to 4pm, use the expression:
(get_hour(ArrivalTime) between 9 AND 11)
To select rows between two arbitrary times, 9:30am to 4pm, use the expression:
(get_hour(ArrivalTime) < 16) && ((get_hour(ArrivalTime) > 10) || (get_hour(ArrivalTime) == 9) && get_minute(ArrivalTime) >= 30)
Issue/Introduction
How to define a time-of-day query range that is date-agnostic
Feedback
Yes
No
Powered by
