/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 vote119 views1 answer
Clear query cache sql server
SQL
11 votes156 views3 answers
Sql line numbers
SQL
0 vote145 views1 answer
Mysql workbench primary key
SQL
3 votes132 views1 answer
Oracle revoke grant
SQL
0 vote131 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote154 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote187 views1 answer
Add week ending date sql server
SQL
0 vote127 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote148 views1 answer
Window function to forward fill
SQL
0 vote155 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL