How is the Time data type stored and displayed?

How is the Time data type stored and displayed?

• A. A date without a time; stored as days since epoch
• B. A duration value; stored as hours
• C. A time without a date; stored as the number of seconds since midnight; converted back to normal time for display
• D. A timestamp with timezone

Answer: (C)

Time values represent a time of day without any date component. To store this efficiently, the value is kept as the number of seconds since midnight. This compact numeric form lets the system perform time-of-day calculations quickly, and when you show it to a user, that seconds count is converted back into a standard time format (hours:minutes:seconds, with possible fractions) for display. The approach naturally supports the full range of a day, from 00:00:00 to 23:59:59 (plus any sub-second precision if needed). Other interpretations would mix in a date, a duration, or a full timestamp with timezone, which isn’t appropriate for a time-of-day type.

Time values represent a time of day without any date component. To store this efficiently, the value is kept as the number of seconds since midnight. This compact numeric form lets the system perform time-of-day calculations quickly, and when you show it to a user, that seconds count is converted back into a standard time format (hours:minutes:seconds, with possible fractions) for display. The approach naturally supports the full range of a day, from 00:00:00 to 23:59:59 (plus any sub-second precision if needed).

Other interpretations would mix in a date, a duration, or a full timestamp with timezone, which isn’t appropriate for a time-of-day type.