/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 votes233 views1 answer
Sqlite3 show columns name
SQL
0 vote176 views1 answer
Count char in java
SQL
1 vote218 views1 answer
Oracle stop
SQL
2 votes242 views1 answer
Ifnull postgres
SQL
0 vote215 views1 answer
Unique index in mysql
SQL
1 vote223 views2 answers
Copy database mysql
SQL
6 votes260 views3 answers
Psql show columns of table
SQL
1 vote211 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote231 views1 answer
Sql server get date of previous sunday
SQL
2 votes203 views1 answer
Postgresql format date dd/mm/yyyy
SQL