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


Darko Topolsek schrieb:

> Hi Karsten,
>
> if you just need date column as a String
> why dont you declare date field in database like String ...
>
Because performance would suck, and I just change them less frequently
then they get read. And as this tool should be quite independent from
the database structure, I don't have an influence on it..

Karsten

> Warm Regards
> Darko Topolsek
> programmer
> urbi et orbi
>
> <news@xxxxxxxxxxxxxxxxx> wrote in message
> news:1135086154.210908.18720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > 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

  • Global Constants
    ... Public strMyVariable As String ... >Is there a way to declare a global variable in Access ... >that all objects in the database are able to reference ...
    (microsoft.public.access.modulesdaovba)
  • Re: CHANGING DATA TYPE
    ... How do you intend to handle Null values coming from the database? ... Declare the variable As Object. ... Later, if you want to distinguish between Null and String, you have to ... members that simplifies this, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cursor among several databases
    ... any database. ... and the string to be serached. ... I using cursor to get this. ... DECLARE cursor_tables CURSOR ...
    (comp.databases.ms-sqlserver)
  • Cursor among several databases
    ... any database. ... and the string to be serached. ... I using cursor to get this. ... DECLARE cursor_tables CURSOR ...
    (comp.databases.ms-sqlserver)
  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)