--- title: "Exact date and time" slug: "exact-date-and-time" tags: ["Reference", "Helix", "Sec Ops and Analytics"] updated: 2026-09-02T19:14:18Z published: 2026-09-02T19:14:18Z canonical: "docs.trellix.com/exact-date-and-time" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Exact date and time 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 | where: - `hh` is the hour in 2-digit format - `mm` is the minute in 2-digit format - `ss` is 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.