frosty frosty - 2 years ago 95
SQL Question

Storing a timestamp in MySQL

If I generate a timestamp with PHP's

and insert/update a row with it, what column type should I use?

I've used
(64-bit) in the past, and I tried
just then and it has the year 2038 error it seems.

Is it okay to just use
to store a timestamp?

Answer Source

use DATETIME datatype,

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 is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.

you may also go through this,

PHP & mySQL: Year 2038 Bug: What is it? How to solve it?

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download