/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

3 votes334 views1 answer
How to remove characters from string in mysql
SQL
0 vote346 views3 answers
Between keyword sql
SQL
0 vote366 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote291 views1 answer
Copy table dbeaver
SQL
0 vote365 views1 answer
Print mysql
SQL
-1 vote347 views3 answers
Psql get last rows
SQL
0 vote360 views1 answer
Android sqlite add column if not exists
SQL
1 vote379 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote333 views1 answer
Stop psql server windows
SQL
4 votes344 views2 answers
Sql table
SQL