Extract what you need
In this exercise you will practice preparing date/time elements by using the EXTRACT()
function.
This exercise is part of the course
Applying SQL to Real-World Problems
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT payment_date,
EXTRACT(___) AS payment_day
FROM payment;