/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

1 vote218 views1 answer
Oracle convert run duration to number
SQL
0 vote208 views1 answer
Sql server alter table add column tinyint
SQL
0 vote273 views1 answer
Insert into table with only identity column
SQL
0 vote213 views2 answers
Dumping sql table
SQL
0 vote3.7K views1 answer
PSQL use LIKE with timestamps
SQL
12 votes215 views5 answers
Rename table in mysql
SQL
1 vote162 views1 answer
Psql kill pid
SQL
0 vote234 views1 answer
Get create sql of hibernqte entity
SQL
7 votes196 views1 answer
Postgres base size
SQL
1 vote209 views1 answer
Add current timestamp in mysql
SQL