/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

5 votes328 views3 answers
Oracle first day of last year
SQL
24 votes318 views2 answers
Alter table delete column
SQL
6 votes332 views2 answers
Drop foreign key
SQL
0 vote383 views1 answer
Finding leap year in sql
SQL
0 vote331 views1 answer
Sql value exists in column
SQL
0 vote328 views1 answer
Oracle step procedure
SQL
9 votes356 views4 answers
Postgresql export database
SQL
2 votes318 views1 answer
Postgresql transaction
SQL
1 vote357 views3 answers
How to pass password to mysql command line
SQL
0 vote345 views1 answer
Sql delete caracter list
SQL