/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

25 votes193 views6 answers
Sql update query
SQL
2 votes185 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote199 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote207 views1 answer
Transaction database with php
SQL
5 votes185 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote202 views1 answer
Sql drop procedure if exists
SQL
0 vote234 views3 answers
How to find all role in mysql
SQL
0 vote183 views1 answer
Sql query to delete row by id
SQL
0 vote191 views1 answer
Tsql default value when no value returned by query
SQL
1 vote200 views2 answers
Insert sqlite
SQL