/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 vote206 views2 answers
Close external port 3306 with iptables
SQL
0 vote233 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote193 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote183 views1 answer
Trim sql oracle
SQL
2 votes278 views3 answers
Mysql cheat sheet
SQL
2 votes224 views1 answer
How to show the whole table in sql
SQL
0 vote226 views1 answer
SQL Server date literal
SQL
0 vote192 views1 answer
Mysql select statement after index
SQL
1 vote262 views1 answer
Show per page table in xampp
SQL
0 vote199 views1 answer
Codeigniter dbforge add index
SQL