MySQL and Date Type columns with 2005-05-00 contents

Hi,
I'm currently trying to read a table from an MySQL database that has a
column of type Date which might contain entries like 2005-05-00.
Everything works as expected when it's used from PHP, but when I do an
getString on the resultSet, the Date Column gets converted to an Java
SQL Date type which does not accept such a Date field. And thus gives
me the result 2005-04-31. But what I really want is just the Date
Column as a STRING. I don't want it to get converted somewhere...
Btw, the 2005-05-00 should represent a Date where the Day is unknown or
not applicable. And I definitly need those cases...
Thanks for any hints in advance,
Karsten

.

Relevant Pages

  • Re: MySQL and Date Type columns with 2005-05-00 contents
    ... > I'm currently trying to read a table from an MySQL database that has a ... > Btw, the 2005-05-00 should represent a Date where the Day is unknown or ... > Thanks for any hints in advance, ...
    (comp.lang.java.databases)
  • Re: Help in making links from mysql!
    ... > I have a mysql database with in the database i have ... > How can i display a link with only the title of the document stored?(easy ... You get the five last entries as you have done, ... You query first only the title and the id of the five last entries and ...
    (alt.php)
  • Re: Delphi2005 BETA
    ... > at leat 10 entries of every path possible, and double that of invalid ... > paths ....on a whim!!! ... > unknown this and unknown that, I can't see my structure diagram for ...
    (borland.public.delphi.non-technical)
  • Re: Bored already ? But also a Thursday spoiler thoughts
    ... material phenomena is unknown and ... One who denies or disbelieves the existence of a God. ... As do many of the entries in A. And B, and C, and...all the way to L. I'm happy to make a note that we should consider these entries for urgent attention...but "urgent" is going to be a relative term here.... ...
    (uk.media.radio.archers)
  • Re: Need some help with multiple PHP/MySQL INSERT statements
    ... > I have a text file of data in a file where the entries are ... > already entered on separate lines in the following form: ... > These have been parsed from a review form that a client already ... > for appropriateness and grammer is to insert it into my MySQL database. ...
    (comp.lang.php)