Blog

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,

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

date_format(timestamp, fmt) – Converts `timestamp` to a value of string in the format specified by

current_date() – Returns the current date at the start of query evaluation. Platforms: WhereOS, Spark,