Analytics Engineering
Start free
← All topics

SQL: Date and Time Functions

10 exercises3 free
  1. 01Extract Year From Order Date
    Free→
  2. 02Calculate How Many Days Old Each Order Is
    Free→
  3. 03Filter Orders Within A 30-Day Window
    Free→
  4. 04Add Six Months To The Order Date
    Locked→
  5. 05Extract The Month And Day From An Order Date
    Locked→
  6. 06Display Order Date In YYYY-MM-DD Format
    Locked→
  7. 07Compute Years Since Hire Date
    Locked→
  8. 08Filter Orders In A Specific Quarter
    Locked→
  9. 09Find Orders Within A Date Range
    Locked→
  10. 10Show The Day Of The Week
    Locked→