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 →