/SQL/Should I use the datetime or timestamp data type in MySQL?

Should I use the datetime or timestamp data type in MySQL?

TIMESTAMP is four bytes vs eight bytes for DATETIME.

Timestamps are also lighter on the database and indexed faster.

The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in YYYY-MM-DD HH:MM:SS format. The supported range is 1000-01-01 00:00:00 to 9999-12-31 23:59:59. The TIMESTAMP data type has a range of 1970-01-01 00:00:01 UTC to 2038-01-09 03:14:07 UTC. It has varying properties, depending on the MySQL version and the SQL mode the server is running in.

DATETIME is constant while TIMESTAMP is affected by the time_zone setting.

Source: stackoverflow.com

Similar codes

12 votes312 views5 answers
Rename table in mysql
SQL
2 votes287 views1 answer
Copy all values of a column to another column in sql in same table
SQL
8 votes296 views1 answer
Sql limit results returned
SQL
0 vote283 views1 answer
How to check xampp mysql password
SQL
8 votes274 views3 answers
Mysql alter table add index
SQL
1 vote306 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote293 views1 answer
Is sql fast
SQL
5 votes264 views2 answers
Mysql where in array
SQL
0 vote284 views1 answer
Sql select inside select sub query
SQL
0 vote307 views1 answer
Dump only data
SQL