/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

2 votes309 views3 answers
Mysql cheat sheet
SQL
16 votes321 views1 answer
CTE statement sql server
SQL
0 vote361 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
19 votes351 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote347 views1 answer
Mysql select inside sum
SQL
0 vote359 views1 answer
Mysql where in maintain order
SQL
7 votes327 views1 answer
Forge server hosting
SQL
0 vote311 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote345 views1 answer
Query params sql insert python f string
SQL
0 vote376 views1 answer
Oracle insert single quote in string
SQL