/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 vote188 views1 answer
How to query all tables mysql at the same time
SQL
4 votes171 views3 answers
Sql find second highest salary employee
SQL
0 vote196 views2 answers
Amazon linux postgresql client
SQL
38 votes259 views4 answers
Count sql
SQL
0 vote187 views1 answer
Sqlite insert or update
SQL
0 vote189 views1 answer
Populate db from command line postgres
SQL
13 votes202 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote192 views1 answer
Postgres list all triggers
SQL
0 vote192 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote175 views1 answer
Como saber si tengo mysql instalado
SQL