round
This section contains reference documentation for the round function.
Round the given time value to nearest bucket start value.
round(timeValue, bucketSize)
Round seconds epoch value to the start value of the 30 seconds bucket to which it belongs.
select round(1639144274, 30) AS rounded
FROM ignoreMe
rounded |
|---|
1639144260 |
Round milliseconds epoch value to the start value of the 5,000 milliseconds bucket to which it belongs.
select round(1639144274000, 5000) AS rounded
FROM ignoreMe
rounded |
|---|
1639144270000 |
Last modified 1yr ago