date_trunc(fmt, ts) – Returns timestamp `ts` truncated to the unit specified by the format model

datediff(endDate, startDate) – Returns the number of days from `startDate` to `endDate`. Platforms: WhereOS, Spark,

Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.DateSeriesUDF More functions can be added to WhereOS via Python

date_range(a,b,c) – Generates a range of integers from a to b incremented by c or

date_sub(start_date, num_days) – Returns the date that is `num_days` before `start_date`. Platforms: WhereOS, Spark, Hive

date(expr) – Casts the value `expr` to the target data type `date`. Platforms: WhereOS, Spark,