/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

5 votes160 views1 answer
Sql use database
SQL
1 vote151 views1 answer
Restart identity postgresql
SQL
0 vote142 views1 answer
Date diff sql
SQL
0 vote144 views1 answer
Sql trim whitespace
SQL
0 vote145 views1 answer
Sql server whoami
SQL
0 vote192 views1 answer
Add computed column to table sql server
SQL
0 vote159 views1 answer
Sql show founctions
SQL
0 vote167 views1 answer
Python connect to mysql in settings.py
SQL
0 vote148 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote143 views1 answer
Oracle list subpartitions
SQL