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