# Milliseconds and Microseconds in TIMESTAMP\_ADD

**URL:** <https://community.dremio.com/t/milliseconds-and-microseconds-in-timestamp-add/7743>\
**Category:** Uncategorized\
**Created:** [July 15, 2021, 9:27am UTC](https://community.dremio.com/t/milliseconds-and-microseconds-in-timestamp-add/7743 "2021-07-15T09:27:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnshearer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/johnshearer/32/3395_2.png) [@johnshearer](https://community.dremio.com/u/johnshearer)\
**Post date:** [July 15, 2021, 9:27am UTC](https://community.dremio.com/t/milliseconds-and-microseconds-in-timestamp-add/7743/1 "2021-07-15T09:27:38Z")

</div>

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](https://github.com/dremio/dremio-oss/blob/398ead8918dc1dd7c2c1e8c4d4e4ba53d78f3fed/sabot/kernel/src/main/java/com/dremio/exec/planner/sql/ConvertletTable.java#L125) - 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