Dates and times

Truncating, bucketing and differencing timestamps. Month-over-month and cohort-style questions live here, and the traps are boundary conditions: inclusive vs exclusive ranges, and days that fall exactly on the edge.

New to this? Read the Date & time functions chapter.

easyDays remaining until subscription expiryTelekom Malaysia · date-timeFree→mediumAttach the policy rate in force on each dateBank Negara Malaysia · date-timeBasic→mediumAverage ride duration, by monthGrab · date-timeBasic→mediumFlag shipments that breached their SLADHL · date-timeFree→mediumMonthly fuel salesPetronas · date-timeBasic→mediumOutage duration in minutesHuawei · date-timeFree→mediumTotal fuel spend per monthSetel · date-timeBasic→hardCount overdue installments by ageing bucketAEON · date-timeBasic→hardFind weekdays with no timesheet entryKPMG · date-timeBasic→