Hello Mark,
in Versions of MySQL prior to 5.0.2 it is only checked that the
year-part ranges from 1000-, the month-part from 1-12 and the
day-part ranges from 1-31 within the date column.
With 5.0.2 of MySQL the Dates must be legal, so 2006-02-31 is no more
possible by default. You can
Hello Rocco,
Thank you for your reply. Clear and simple. :)
I couldn't upgrade the MySQL server on my production server just yet, but
I upgraded the local test MySQL server on a Windoze machine. And it worked
like a charm. :) I just needed to create a one-time table of how many days
there are