/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 vote248 views1 answer
Sql count matching group by
SQL
1 vote190 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
5 votes205 views3 answers
Day of week postgresql
SQL
0 vote276 views1 answer
Having all mysql
SQL
0 vote178 views1 answer
Postgres add prefix to primary key
SQL
0 vote175 views2 answers
Raise notice in postgresql function
SQL
2 votes195 views1 answer
Add new column not null sql server
SQL
10 votes173 views5 answers
Mysql create user
SQL
0 vote196 views1 answer
How to join result table in mysql
SQL
0 vote170 views2 answers
Mysql slave status
SQL