/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 vote345 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote368 views1 answer
Oracle sql log to console
SQL
3 votes379 views1 answer
Create a table with an id in mysql
SQL
0 vote352 views1 answer
Use where instead of join
SQL
0 vote400 views1 answer
How to inner join 4 tables in sql
SQL
0 vote357 views1 answer
Incorrect datetime value sql table error 1292
SQL
35 votes365 views6 answers
Postgres
SQL
13 votes335 views2 answers
Sqlite rename column
SQL
1 vote385 views1 answer
What is in condition in sql
SQL
19 votes374 views5 answers
Date between in mysql
SQL