Re: date comes out as '0000-00-00'

2002-02-15 Thread TAKAHASHI, Tomohiro
Hi, Could you tell me about your TABLE-definition and version number of your JDBC Driver? I will check that problem. "Stancescu, Catalina" wrote: > > I have a servlet in which I connect through a mysql driver to the > database. The servlet has a string that represents the date in the > f

Re: date comes out as '0000-00-00'

2002-02-14 Thread Cindy
>> I have a servlet in which I connect through a mysql driver to the >>database. The servlet has a string that represents the date in the >>format 'MM/DD/YY'. >> >> When I am trying to insert this date, I get sometimes the correct date, >>sometimes I get the '-00-00'. >> >>Here is t

Re: date comes out as '0000-00-00'

2002-02-14 Thread DL Neil
Hi Catalina, I have a servlet in which I connect through a mysql driver to the database. The servlet has a string that represents the date in the format 'MM/DD/YY'. When I am trying to insert this date, I get sometimes the correct date, sometimes I get the '-00-00'. Here is the code: Str

Re: date comes out as '0000-00-00'

2002-02-14 Thread John McConnell
This doesn't really answer your question, but whenever I deal with dates I convert them to Unix and store them in the database, and then convert them back when I use them. Sorting dates doesn't seem to work as well in a non-unix format, and with UNIX dates you have much more control over the

date comes out as '0000-00-00'

2002-02-14 Thread Stancescu, Catalina
Hi , I have a servlet in which I connect through a mysql driver to the database. The servlet has a string that represents the date in the format 'MM/DD/YY'. When I am trying to insert this date, I get sometimes the correct date, sometimes I get the '-00-00'. Here is the code: String s