I discovered an odd problem today...
While testing out some forms I have built, I have two fields...one which requires you to enter a date on a 00/00/00 format, and another that auto populates the field with the current date in the 00/00/00 format.
While testing the manually entered one only after discovering the auto populating one was returning 00/00/00 by default, I came across this weirdness:
When manually entering a date like 02/02/02 it shows up fine as entered in the database, and display's properly. But when I enter in today's date: 09/25/01, I get all zero's in the database and the infamous Epoch date gets displayed.
Any reason why this happens? Have I possibly coded something wrong? Or is there possibly a bug in the mySQL version I'm using?
Any help is immensely appreciated.
While testing out some forms I have built, I have two fields...one which requires you to enter a date on a 00/00/00 format, and another that auto populates the field with the current date in the 00/00/00 format.
While testing the manually entered one only after discovering the auto populating one was returning 00/00/00 by default, I came across this weirdness:
When manually entering a date like 02/02/02 it shows up fine as entered in the database, and display's properly. But when I enter in today's date: 09/25/01, I get all zero's in the database and the infamous Epoch date gets displayed.
Any reason why this happens? Have I possibly coded something wrong? Or is there possibly a bug in the mySQL version I'm using?
Any help is immensely appreciated.