/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

15 votes325 views6 answers
Laravel db transaction
SQL
0 vote332 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote337 views1 answer
Influxdb list all tags for a measurement
SQL
2 votes299 views1 answer
Oracle number to percentage
SQL
0 vote302 views1 answer
Postgres sql alter table delete row
SQL
0 vote293 views1 answer
Mysql into outfile with headers
SQL
0 vote363 views1 answer
Sql check if field is not null
SQL
0 vote314 views1 answer
Sql server on mac m1
SQL
0 vote298 views1 answer
How to set all the min and sec data to zero in sql server
SQL
2 votes288 views1 answer
Match in sql server
SQL