/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

1 vote163 views1 answer
Date in where on datetime column clause mysql
SQL
3 votes151 views1 answer
Laravel paginate raw sql
SQL
0 vote156 views1 answer
Insert overwrite table in mysql in nifi
SQL
1 vote160 views2 answers
How to check if sql query is correct online
SQL
20 votes168 views6 answers
Mysql reset auto increment
SQL
1 vote162 views1 answer
How to fetch alternate records from two tables
SQL
2 votes168 views1 answer
Oracle percentage
SQL
0 vote200 views1 answer
Insert into table with only identity column
SQL
0 vote162 views1 answer
Create database like
SQL
0 vote177 views2 answers
Unique key
SQL