Hello,
Please excuse me if this has been posted in the wrong spot.
I'm storing historical information in a MySQL database and am using the date
field formatted in YYYY-MM-DD.
For the most part, the data entered is correct and uses the full YYYY-MM-DD
format, however, I've got numerous dates that are incomplete. For example:
an event happened in 1967, but the exact month and day are not known. I've
been storing that data, in other forms, as 1967-00-00 but now dropping it
into MySQL, when extracting that information using PHP, I'm running into
errors where a date like '1967-00-00' would be deemd as having occured in
1966?
As far as the data goes, here's some sample dates that I need to be able to
handle.
AS ENTERED EQUIVILANT LONG FORM
-----------------------------------------------------------------------
1965-08-12 August 12, 1965
1965-08-00 August 1965
1965-00-00 1965
Is this an effective means of handling this? Are there better methods? How
can I get PHP to properly convert those dates? (I am using the
ADODB-TIME.PHP class library too to help avoid the 1970-01-01 date
restrictions that PHP internally has)
Thanks for your help!
_________________________________________________________________
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
