/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

18 votes277 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
6 votes290 views1 answer
How to get the size of the database in postgresql
SQL
2 votes279 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
2 votes261 views3 answers
Application.properties spring boot mysql
SQL
3 votes293 views2 answers
Sql server current date without time
SQL
0 vote261 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote330 views3 answers
Postgres trim string
SQL
1 vote298 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote224 views1 answer
How to connect sql server using ip address in c#
SQL
3 votes280 views1 answer
RENAME table pl sql
SQL