Manipulating Datetime Values in Apache Pinot: Reference and Examples

Format Unix timestamp as datetime string

Use toDateTime(source_column, format). All formats accepted by JodaTime are supported.

• Query:

  select created_at, toDateTime(created_at,'yyyy-MM-dd HH:mm:ssZZ') as created_at_str from my_table

• Sample results:

  created_at      created_at_str
  1744045102745   2025-04-07 16:58:22+00:00
  1744045114395   2025-04-07 16:58:34+00:00
  1744045166826   2025-04-07 16:59:26+00:00