Session Ready
Exercise

Extract what you need

In this exercise you will practice preparing date/time elements by using the EXTRACT() function.

Instructions 1/3
undefined XP
  • 1
    • EXTRACT the DAY from payment_date and return this column AS the payment_day.
    • 2
      • EXTRACT the YEAR from payment_date and return this column AS the payment_year.
    • 3
      • EXTRACT the HOUR from payment_date and return this column AS the payment_hour.