We help IT Professionals succeed at work.
Get Started

MySQL Dates Older then 1970

Pyromanci
Pyromanci asked
on
495 Views
Last Modified: 2012-08-14
I have been trying to find a solution to this without much luck. Most of my google searches have turned up this related to linux timestamps and not a actually Date/timestamp fields.

The problem I'm running into seems to be when ever a item is inserted into a date, or timestamp field that is before 1970/01/01, there is a warning then field is then set to 0000-00-00 00:00:00 or 0000-00-00.

I really need to find a solution to this to allow these. Much of these items are birth dates. I don't know if a newer version of MySQL has this solved or if there any variables or settings that can be adjusted to take of this.

The version i'm using is 5.0.77.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 22 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE