/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

17 votes133 views6 answers
Current date in sql
SQL
6 votes136 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote131 views1 answer
Get number of table colums in sql query
SQL
17 votes138 views6 answers
Change column name in sql
SQL
7 votes133 views4 answers
How to reset the identity column in sql server
SQL
0 vote132 views1 answer
Sql server alter table column nullable
SQL
1 vote134 views1 answer
Oracle difference between two dates in years
SQL
-1 vote109 views1 answer
Mysql if example
SQL
1 vote126 views3 answers
Rename table snowflake
SQL
5 votes157 views2 answers
Mysql where in array
SQL