/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

1 vote377 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote342 views1 answer
Rabbitmq service not starting
SQL
27 votes379 views5 answers
Mysql set password for user
SQL
31 votes358 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote385 views1 answer
Sql server select rows by distinct column
SQL
11 votes343 views2 answers
Docker create postgres db
SQL
1 vote352 views4 answers
Mysqldump 1 table only
SQL
0 vote371 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote402 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
-2 votes351 views1 answer
Remove root password mysql
SQL