Dates and Times

Dates in FSQL can be described as relative dates, ISO 8601 dates, or epoch timestamps.

Relative Dates

Relative dates describe a time relative to when FSQL receives your query, and can be described in hours, days, weeks, or months.

Supported time units:

• Minutes: m, min, mins, minute, minutes
• Hours: h, hr, hour, hrs, hours
• Days: d, day, days
• Weeks: w, week, weeks, wk, wks
• Months: mo, mos,month, months, mon, mons

Examples:

QUERY ... BEFORE 24hrs
QUERY ... AFTER 7d
QUERY ... AFTER 1 month

Relative dates can also be combined:

QUERY ... BEFORE 2 weeks 3 days

ISO 8601 Dates

Absolute dates can be described using the ISO 8601 date format.

ISO 8601 dates must be quoted and must contain a month, day, and year. They may optionally include hours and minutes, seconds, and timezone offsets as hours and minutes from UTC.

QUERY ... AFTER '2025-04-01'
QUERY ... AFTER '2025-04-01 17:30'
QUERY ... AFTER '2025-04-01 17:30:00'
QUERY ... AFTER '2025-04-01 17:30:00.1234'
QUERY ... AFTER '2024-04-01 17:30-05:00'
QUERY ... AFTER '2024-04-01 17:30:00.1234-5:00'

Epoch Timestamps

Dates described in epoch timestamp format (Unix timestamps) should be described unquoted as seconds since January 1st, 1970, and are always assumed to be in UTC.

QUERY ... BEFORE 1746109163