/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 vote224 views1 answer
Mysql server not running
SQL
0 vote230 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote230 views1 answer
How convert into in in sql query
SQL
0 vote259 views1 answer
How to define a non primary composite key in sql
SQL
-1 vote236 views3 answers
Compute age mysql
SQL
0 vote242 views3 answers
Join
SQL
0 vote255 views1 answer
Mysql edit trigger
SQL
0 vote222 views1 answer
Python mysql executemany
SQL
0 vote245 views1 answer
Count database access django
SQL
0 vote238 views1 answer
Import sql in postgresql
SQL