TQL supports searches based on exact date and time using the following syntax.
| Calendar date with the year, month, and day |
| Calendar date with the year and month |
where:
yyyyis the year in 4-digit number formatmmis the month in 2-digit number formatddis the day in 2-digit number format
| Hours, minutes, and seconds |
| Hours and minutes |
where:
hhis the hour in 2-digit formatmmis the minute in 2-digit formatssis the second in 2-digit format
Examples:
eventtime='2022-04-08T21:00:49.669Z'
Returns events that occurred at 9:00:47.669 p.m. on April 8, 2022.
eventtime="2022-04-08T19"
Returns events that occurred during the hour of 7:00 p.m. on April 8, 2022.
eventtime>"2022-04-08T23:00:00"
Returns events that occurred after 11:00 p.m. on April 8, 2022.
endtime='2022-04-08T15:24:55.157Z'
Returns events with an end time of 3:24:55.157 p.m. on April 8, 2022.
eventtime>"2022-04-07T01:10" eventtime<"2022-04-07T01:20"
Returns events that occurred within the specified 10-minute time range.