Examveda

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

A. Yes

B. No

C. Depends

D. None of the mentioned

Answer: Option A

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous