Which data type stores both date and time?

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

Answer: (A)

The key idea here is choosing a data type that can represent both a calendar date and a time of day. TIME holds only the clock time (hours, minutes, seconds) without any date. DATE holds only the calendar date (year, month, day) without a time. A type that stores both date and time is TIMESTAMP, and in many databases it is designed to capture a precise moment in time, sometimes with time-zone information and sometimes with special behavior like auto-updating on row changes. DATETIME also stores date and time in many systems, but TIMESTAMP is the one commonly used when the value is meant to represent an exact point in time across contexts. So for a value that includes both date and time, TIMESTAMP is the appropriate choice.