to_weeks(duration: duration) -> float64

Convert a duration to a number of weeks.

The input is always of type duration, the output is a float64 representing the number of weeks (whole and fractions) of that duration.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Time

Examples

make_col weeks:to_weeks(stopTime - startTime)

Assuming stopTime and startTime are timestamps, subtracting them yields a duration. That duration is then converted to number of weeks using to_weeks.