/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 vote134 views2 answers
How to use aggregate functions in sql
SQL
1 vote123 views1 answer
Sql delete row with auto increment
SQL
0 vote127 views1 answer
Mysql select where field like in list
SQL
1 vote153 views1 answer
Oracle select row max date
SQL
32 votes129 views6 answers
Insert select
SQL
1 vote118 views2 answers
Mysql type conversion
SQL
0 vote144 views1 answer
Sql decimal to 2 places
SQL
0 vote127 views1 answer
Pl/sql loop example
SQL
2 votes120 views1 answer
Oracle sql drop table purge
SQL
0 vote120 views1 answer
Ms sql database data size
SQL