truncateTimeColumn() function
The truncateTimeColumn()
function truncates all input table _time
values to a specified unit.
*Function type: Transformation*
truncateTimeColumn(unit: 1s)
Parameters
unit
The unit of time to truncate to.
*Data type: Duration*
Only use 1
and the unit of time to specify the unit
. For example: 1s
, 1m
, 1h
.
Examples
Truncate all time values to seconds
from(bucket:"example-bucket")
|> range(start:-1h)
|> truncateTimeColumn(unit: 1s)
Function definition
import "date"
truncateTimeColumn = (unit, tables=<-) =>
tables
|> map(fn: (r) => ({
r with _time: date.truncate(t: r._time, unit:unit)
})
)