/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

3 votes284 views3 answers
Stop mysql service ubuntu
SQL
0 vote311 views2 answers
Mysql decimal remove trailing zeros
SQL
16 votes287 views1 answer
CTE statement sql server
SQL
3 votes299 views1 answer
Select nextval from sequence sql
SQL
3 votes303 views2 answers
Sql end of month
SQL
2 votes317 views2 answers
Postgres trigger insert into another table
SQL
1 vote322 views1 answer
Sql server today minus n
SQL
0 vote327 views2 answers
Oracle chain rules
SQL
6 votes292 views2 answers
Mysql set primary key
SQL
0 vote301 views1 answer
Is not sql
SQL