Exact date and time

Prev Next

TQL supports searches based on exact date and time using the following syntax.

yyyy-mm-dd

Calendar date with the year, month, and day

yyyy-mm

Calendar date with the year and month

where:

  • yyyy is the year in 4-digit number format

  • mm is the month in 2-digit number format

  • dd is the day in 2-digit number format

hhmmss

Hours, minutes, and seconds

hh:mm

Hours and minutes

Examples:

time>'2025-11-10T06:47:34'

time<'2025-11-10T06:57:34'

Returns events that occurred after 11:00 p.m. on April 8, 2022.

time='2025-10-28T12:30:01.000Z'

Returns events with an end time of 12:30:01.000 pm on October 28, 2025

time<'2025-11-10T06:57:34'time>"2022-04-07T01:10"

Returns events that occurred within the specified 10-minute time range.