Which data type is used to store date values in the format year-month-day?

• A. Time
• B. Date
• C. Timestamp
• D. Datetime

Answer: (B)

Storing a calendar date without any time component uses a data type designed for date-only values. A date value is represented as year-month-day, such as 2024-07-18, with no hours, minutes, or seconds. That’s exactly what the Date type holds, making it the best fit for values in the year-month-day format.

The other types include a time part (Time stores hours, minutes, seconds) or both date and time (Timestamp or Datetime). While they store date and time together, they wouldn’t be suitable when you only need the date portion.