/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 vote194 views1 answer
Add column alter table default value
SQL
0 vote216 views1 answer
Mysql not defined
SQL
0 vote205 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote209 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
2 votes223 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote209 views1 answer
How to get specific salary in sql
SQL
1 vote185 views1 answer
Login to database mysql terminal
SQL
0 vote242 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
6 votes216 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote223 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL