SQL Functions

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_format(timestamp, fmt) – Converts `timestamp` to a value of string in the format specified by