Exercise

Extract what you need

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

Instructions 1/3

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.