1. 学ぶ
    2. /
  2. プロジェクト
    3. /
  3. Applying SQL to Real-World Problems
Connected

演習

Extract what you need

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

指示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.