Get startedGet started for free

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

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT payment_date,
  EXTRACT(___) AS payment_day 
FROM payment;
Edit and Run Code