Which data type stores only the time of day without a date?

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

Answer: (B)

Storing a time of day without any date is what the TIME data type is for. TIME holds values like 08:30:00 or 23:59:59, and may include fractions of a second, but it does not store any calendar date. This makes it ideal for fields such as start_time or alarm_time where only the clock time matters.

Date stores just the calendar date, without any time component. DATETIME or TIMESTAMP include both date and time, so they would carry information about a specific day as well as the time, which isn’t what you want here. So the best choice for representing a time-of-day only is TIME.