/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 vote131 views1 answer
Sql date time query find
SQL
8 votes107 views3 answers
Mysql alter table add index
SQL
1 vote109 views2 answers
Sql where keyword
SQL
1 vote139 views1 answer
Best configuration for display table in sqlplus
SQL
1 vote111 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote124 views1 answer
Mysql count with two joins
SQL
0 vote111 views1 answer
QCompleter con sql
SQL
0 vote127 views2 answers
How to display enum value sql server
SQL
0 vote71 views1 answer
Denied
SQL
0 vote124 views1 answer
Postgres clear table
SQL