/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 vote103 views1 answer
QUERY JPQL
SQL
0 vote121 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote103 views1 answer
Get number of tables in database sql
SQL
0 vote108 views1 answer
Add alternate add column sql
SQL
0 vote96 views1 answer
How to count null values in sql
SQL
5 votes108 views2 answers
Sql server port number
SQL
0 vote105 views1 answer
Double in sql server example
SQL
4 votes98 views1 answer
Postgresql show current database
SQL
13 votes100 views2 answers
Mysql order by multiple columns
SQL
1 vote99 views3 answers
Mariadb add foreign key
SQL