/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

-2 votes181 views2 answers
Sqlserver docker
SQL
2 votes297 views1 answer
Mysql create user with remote access
SQL
0 vote175 views1 answer
What does leave do in mysql
SQL
0 vote177 views1 answer
Get role postgres
SQL
0 vote243 views1 answer
Sql alter table add column if exists
SQL
12 votes164 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote169 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote182 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote176 views2 answers
Select a row include list of array with join two table SQL
SQL
-1 vote162 views1 answer
Sql getdate date only
SQL