All recipes

Basics

• Convert a String to a Date in SQL (per Dialect)3 min
• Get the Current Date & Time in SQL (per Dialect)2 min
• Format a Date as a String in SQL (per Dialect)3 min

Arithmetic

• Add or Subtract Days, Months & Years in SQL (per Dialect)3 min
• Calculate Age in Years from a Birthdate in SQL (per Dialect)3 min
• Days Between Two Dates in SQL (DATEDIFF per Dialect)3 min

Parts & truncation

• Truncate a Timestamp to Day/Week/Month in SQL (DATE_TRUNC per Dialect)3 min
• Day of Week & Week Number in SQL (per Dialect)3 min
• Extract Year, Month or Day from a Date in SQL (EXTRACT per Dialect)2 min

Ranges

• First & Last Day of the Month in SQL (per Dialect)2 min
• Generate a Series of Dates in SQL (Calendar Table per Dialect)4 min
• Group / Aggregate by Month (or Week) in SQL (per Dialect)3 min

Timestamps & TZ

• Filter Rows in a Date Range in SQL (Last 7/30 Days, This Month)3 min
• Convert a Timestamp Between Time Zones in SQL (per Dialect)3 min
• Unix / Epoch Timestamp ↔ Date in SQL (per Dialect)3 min