/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 vote169 views1 answer
Oracle current date minus 1 day
SQL
4 votes152 views1 answer
Group by mysql and concatenate string
SQL
2 votes159 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote144 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote143 views1 answer
SQLite order random
SQL
1 vote153 views1 answer
Blob datatype in mysql
SQL
0 vote146 views1 answer
Mysql return column names when table is empty
SQL
0 vote163 views1 answer
Reset postgres table index to next max value
SQL
4 votes155 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
2 votes140 views1 answer
How to delete view in sql
SQL