Hi all, I'm having a few major issues with Date over jdbc.
i) when i read a date out from my mysql database it cast it into java.util.Date to store in an object(errors if i try to store as java.sql.Date). Later on i have major problems trying to compar this date object...
ii) the second probelm is writing date to the db through jdbc. I set the date from todays date, cast it to java.sql.Date but when i write it to the db. i get 00-00-0000 in the db
Obviosly there is somethign strange going on between java.util.Date and java.sql.Date. Any help would be appreciated.
Does that mean you can't compare java.sql.Date fields properly? I need the application to work out whether an item is out of date, so the precision is in terms days.
Also how do you write dates or timestamps through jbbc, as at the moment I have to use a sql based function like now(), because i simply get nulls if i attempt to pass a date. What i've been doing converting a java.util.Date to java.sql.Date, and passing that date across in the jdbc code? Is this not correct.