/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

1 vote165 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote182 views2 answers
Get item by composite primary key mysql
SQL
0 vote156 views1 answer
Oracle list chain steps
SQL
0 vote176 views1 answer
Oracle change password expiration policy
SQL
0 vote198 views1 answer
Create a plsql object
SQL
0 vote154 views1 answer
Prepared statement mysql java delete selected rows
SQL
1 vote165 views1 answer
Get table which have specific columns in mysql
SQL
2 votes217 views3 answers
How to replace null values in sql
SQL
4 votes185 views2 answers
Delete all table oracle
SQL
0 vote186 views1 answer
How to remove quotes from a string in ssis load file
SQL