Blog

day(date) – Returns the day of month of the date/timestamp. Platforms: WhereOS, Spark, Hive Class:

dayofmonth(date) – Returns the day of month of the date/timestamp. Platforms: WhereOS, Spark, Hive Class:

dayofweek(date) – Returns the day of the week for date/timestamp (1 = Sunday, 2 =

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