/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 vote271 views1 answer
Add sqlcmd to path linux
SQL
1 vote257 views3 answers
Rename table snowflake
SQL
27 votes261 views4 answers
Get all tables with column name sql
SQL
15 votes264 views3 answers
Find duplicate keys in mysql
SQL
0 vote281 views1 answer
How to find symmetric pairs in sql
SQL
0 vote267 views1 answer
Mysql make date from 2 column
SQL
1 vote276 views1 answer
Trim leading zeros in sql
SQL
0 vote260 views1 answer
How to get table current identity value in sql server
SQL
6 votes265 views1 answer
Identify primary key in oracle table
SQL
0 vote270 views1 answer
Tsql pad left
SQL