/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

7 votes343 views2 answers
MySQL IF without else
SQL
7 votes313 views6 answers
Reset identity column in sql server
SQL
1 vote314 views1 answer
Show structure of table in sql
SQL
2 votes342 views1 answer
Sql percentage with % rounded down
SQL
0 vote325 views1 answer
Sql tablo sp
SQL
2 votes272 views1 answer
Mysql admin u root p password change password
SQL
1 vote331 views1 answer
How to lock table in mysql
SQL
0 vote335 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote307 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote316 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL