/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 vote221 views1 answer
UseSqlServer no definition
SQL
1 vote163 views1 answer
Unique vs distinct sql
SQL
0 vote198 views1 answer
Ms sql filter all sympbol
SQL
14 votes235 views2 answers
Sql cast
SQL
0 vote187 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote192 views1 answer
Fill up postgres db
SQL
0 vote198 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote201 views1 answer
Oracle procedure chain step
SQL
1 vote180 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote208 views1 answer
Sql server concat null
SQL