I was thinking of using TIMESTAMP to store the date+time, but I read that there is a limitation of year 2038 on it. Instead of asking my question in bulk, I preferred to break it up into small parts so that it is easy for novice users to understand as well. So my question(s):[*]What exactly is the Year 2038 problem?[*]Why does it occur and what happens when it occurs?[*]How do we solve it?[*]Are there any possible alternatives to using it, which do not pose a similar problem?[*]What can we do to the existing applications that use TIMESTAMP, to avoid the so-called problem, when it really occurs?Thanks in advance.
PHP & mySQL: Year 2038 Bug: What is it? How to solve it?
- Thread starter sanata
- Start date