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.