/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 vote119 views2 answers
Mssql show database size
SQL
0 vote131 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote122 views2 answers
Starting mysql service from mac
SQL
0 vote185 views1 answer
Import sql dump into postgresql database
SQL
0 vote120 views1 answer
Product of a column in mysql
SQL
8 votes139 views1 answer
Mysql restore database
SQL
0 vote129 views1 answer
Odd record sql query
SQL
0 vote142 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote138 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote126 views1 answer
Python list from sql
SQL