/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 vote149 views1 answer
Show per page table in xampp
SQL
0 vote145 views1 answer
Neo4j command to run script file
SQL
0 vote144 views1 answer
Sql revert migration
SQL
0 vote140 views1 answer
How to add session data into mysql database from button
SQL
2 votes183 views1 answer
Creating a view SQL
SQL
0 vote145 views1 answer
Select row with latest date mysql
SQL
0 vote144 views1 answer
Exit psql
SQL
4 votes141 views1 answer
Data types in sql
SQL
0 vote129 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote154 views2 answers
How to get the date from datetime in mysql
SQL