/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

0 vote139 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote139 views1 answer
Nth max in my sql
SQL
1 vote145 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote151 views1 answer
Oracle sql copy table without data
SQL
0 vote132 views1 answer
How to create an SQL save method in ruby
SQL
1 vote141 views3 answers
Postgresql connect to database
SQL
2 votes148 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
3 votes147 views1 answer
Sql server version query
SQL
0 vote145 views1 answer
Sql query to delete row by id
SQL
0 vote154 views1 answer
Query params sql insert python f string
SQL