/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

5 votes74 views1 answer
Postgres upsert
SQL
0 vote69 views1 answer
Delete all rows from table sqlite
SQL
3 votes135 views3 answers
Update con select postgresql
SQL
0 vote127 views1 answer
Nodejs sql get one to many relationship as array
SQL
6 votes130 views3 answers
What is where in sql
SQL
1 vote109 views1 answer
Floor function in sql oracle
SQL
0 vote170 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
-1 vote116 views1 answer
Can pandas fetch data from sql
SQL
1 vote109 views1 answer
Reutrn string after character sql
SQL
0 vote121 views1 answer
Mysql count with two joins
SQL