/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 vote193 views1 answer
Oracle query to find schema you are working on
SQL
2 votes195 views1 answer
Oracle block
SQL
0 vote184 views3 answers
Sql all columns
SQL
4 votes190 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote189 views1 answer
Sql declare variable single line
SQL
1 vote161 views2 answers
Into sql
SQL
6 votes195 views1 answer
Oracle pl sql source
SQL
0 vote184 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote201 views2 answers
Mysql switch case
SQL
1 vote168 views1 answer
How to check the mysql version mac
SQL