/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 vote335 views1 answer
T sql cursor tr
SQL
3 votes315 views3 answers
Stop mysql service ubuntu
SQL
0 vote333 views1 answer
Sql select min
SQL
0 vote327 views1 answer
How to get employee having maximum experience in mysql
SQL
13 votes302 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
6 votes369 views2 answers
Foreign key sqlite3 python
SQL
0 vote334 views2 answers
Identity column in sql server
SQL
0 vote338 views1 answer
Sql server convert to guid
SQL
6 votes380 views2 answers
Oracle trigger
SQL
0 vote417 views1 answer
Sqlite display headers on columns
SQL