/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

3 votes283 views2 answers
Mysql HAVING
SQL
0 vote311 views1 answer
The fetch keyword oracle
SQL
0 vote295 views1 answer
Mariadb select limit offset
SQL
1 vote292 views2 answers
Sql now - 1 day
SQL
0 vote290 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote307 views2 answers
MySQL PARTITION BY month automatically
SQL
2 votes297 views1 answer
Power query concatenate
SQL
0 vote301 views1 answer
Mssql + bit + in python orm
SQL
0 vote290 views1 answer
Mysql group by range
SQL
-2 votes299 views2 answers
Union vs union all in sql
SQL