/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

0 vote247 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote206 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote196 views1 answer
Sql get table last modified time
SQL
1 vote224 views3 answers
Sql union
SQL
0 vote216 views1 answer
Stored procedures example
SQL
7 votes202 views1 answer
Connect mysql docker
SQL
1 vote210 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote231 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote225 views3 answers
Read all columns of a table sql
SQL
0 vote203 views1 answer
Postgres in operator with comma separated values
SQL