/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 vote249 views2 answers
Py sqlite if entry exists
SQL
0 vote237 views1 answer
Difference between db.query and db.execute
SQL
0 vote245 views1 answer
Hashpass
SQL
19 votes250 views5 answers
Date between in mysql
SQL
1 vote257 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote232 views1 answer
Get week day name sql server
SQL
4 votes270 views1 answer
Sql delete multiple conditions
SQL
1 vote269 views2 answers
Full join
SQL
0 vote229 views1 answer
Sql last 7 days
SQL
1 vote235 views1 answer
Apex select list ORA-20999
SQL