/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 vote103 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
4 votes111 views1 answer
Oracle delete last row
SQL
0 vote106 views1 answer
Drop specific row postgresql
SQL
0 vote100 views1 answer
Database db connection string format
SQL
39 votes174 views4 answers
Select duplicates in sql
SQL
1 vote126 views1 answer
Oracle drop job if exists
SQL
0 vote64 views1 answer
Now() -1 mysql
SQL
11 votes170 views2 answers
Sql between date range
SQL
23 votes113 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote136 views3 answers
Get count of null in column sql
SQL