/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 votes255 views1 answer
Install sqlite npm
SQL
0 vote271 views1 answer
Mysql check datetime equals date
SQL
0 vote267 views1 answer
Import sql dump into postgresql database
SQL
0 vote274 views2 answers
Get top 1 row of each group
SQL
0 vote271 views1 answer
Check for directory in bash
SQL
5 votes303 views1 answer
Add column table sql default value
SQL
0 vote291 views2 answers
Execute stored procedure without db set
SQL
0 vote309 views1 answer
Bigrock database connection string
SQL
3 votes264 views3 answers
Docker create postgresql database
SQL
6 votes259 views2 answers
Return columns from table sql
SQL