/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

2 votes167 views1 answer
How to create sql database
SQL
1 vote178 views1 answer
Sql how to duplicate a table
SQL
0 vote171 views1 answer
Equi joins in oracle
SQL
31 votes175 views3 answers
SQL Server change column data type
SQL
0 vote274 views1 answer
Restart serial number for postgres
SQL
-1 vote192 views1 answer
Brisanje dupliranih konatakata
SQL
3 votes166 views3 answers
Remove all spaces from string sql
SQL
0 vote188 views1 answer
Less than date query sqlachemy
SQL
1 vote180 views1 answer
Where to locate set password for mysql
SQL
1 vote189 views1 answer
Spark sql convert string to date
SQL