1Z0-909 · Question #37
Which two differences exist between the timestamp and date time data types?
The correct answer is B. timestamp uses less storage space. D. timestamp converts the value based on the session time zone. TIMESTAMP uses only 4 bytes compared to DATETIME's 8 bytes (B), and it automatically converts stored UTC values to match the current session's time zone setting, while DATETIME stores exactly what you insert with no conversion (D). Option A is backwards - DATETIME actually has…
Question
Which two differences exist between the timestamp and date time data types?
Options
- Atimestamp has larger range of values.
- Btimestamp uses less storage space.
- Ctimestamp stores more decimal points in seconds
- Dtimestamp converts the value based on the session time zone.
- Etimestamp stores the interval between two dates.
How the community answered
(14 responses)- A7% (1)
- B93% (13)
Explanation
TIMESTAMP uses only 4 bytes compared to DATETIME's 8 bytes (B), and it automatically converts stored UTC values to match the current session's time zone setting, while DATETIME stores exactly what you insert with no conversion (D). Option A is backwards - DATETIME actually has the wider range (year 1000–9999) versus TIMESTAMP's narrower range (1970–2038). Option C is incorrect because both types support the same fractional seconds precision (up to 6 decimal places/microseconds). Option E describes an INTERVAL type, not TIMESTAMP - both TIMESTAMP and DATETIME store a single point in time, not a duration between two dates. Memory tip: Think "TimeStamp = TimeSmaller + TimeZone-Smart" - it's the smaller, timezone-aware sibling of DATETIME.
Topics
Community Discussion
No community discussion yet for this question.