/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 vote241 views1 answer
Trim sql oracle
SQL
0 vote262 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote289 views1 answer
Get role postgres
SQL
16 votes281 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote268 views1 answer
Hackerrank sql test solutions
SQL
0 vote255 views1 answer
What is logical database schema
SQL
3 votes239 views1 answer
Sql several or
SQL
1 vote261 views1 answer
Postgresql delete cascade
SQL
0 vote268 views1 answer
Sql comand for removing data from table
SQL
13 votes279 views5 answers
Alter table query sql server change column
SQL