/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 vote316 views1 answer
How to install Firebird
SQL
1 vote319 views1 answer
Select not matching data from two tables
SQL
37 votes349 views3 answers
Postgresql insert column
SQL
6 votes353 views2 answers
Database url postgres
SQL
1 vote368 views1 answer
Oracle difference between two dates in years
SQL
0 vote372 views1 answer
C# mysql data reader from two tables
SQL
0 vote435 views1 answer
Compress sql file database ubuntu
SQL
1 vote354 views1 answer
Oracle grant select on schema
SQL
0 vote320 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote328 views1 answer
Oracle query to see what scema i am working in
SQL