deflate

deflate(TEXT data [, const int compressionLevel]) – Returns a compressed BINARY object by using Deflater.

day

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

dayofmonth

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

dayofweek

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

date_trunc

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

datediff

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