Milliseconds and Microseconds in TIMESTAMP_ADD

We’re trying to round a timestamp to the nearest second.

There’s currently no round function in Dremio, so we wanted to use DATE_TRUNC instead, unfortunately that doesn’t currently support Milliseconds nor Seconds - TODO(DX-11268)

Is there a timeline for this feature? and/or an implementation of round?

We currently have resolved by multiply a 1 second interval by 0.5

  • DATE_TRUNC('second', value_to_round + 0.5 * INTERVAL '1' SECOND)

Thanks so much