ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Is "Datetime" and "Timestamp" are same data type?

Answer & Solution
Correct Answer: Option A
This question asks about the relationship between "Datetime" and "Timestamp" data types in MySQL.
Let's break it down:
* Datetime: Stores a date and time value. It can represent dates from January 1, 1970, to December 31, 9999.
* Timestamp: Also stores a date and time value, but it has some unique features:
* It usually takes up less storage space than "Datetime".
* It can be automatically updated when a row is modified. This makes it useful for tracking changes in data.
So, are they the same? No! They have different storage requirements and behavior.
The correct answer is Option B: No.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.