Problem Reading/Writing Date

[Jamie Wool]

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...

    java.sql.Date d= new java.sql.Date(new java.util.Date().getTime());
 if (((Product)products.get(productId)).getSellByDate().compareTo(d) == 0){
       //Product is out of date today, so increase push    
    }
        
    }

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.

Cheers

[Yongping Wang]

You better use Timestamp instead of Date.
Yongping

[Jeanne Boyarsky]

To expand on Yongping's comment:

- java.sql.Date is the date without any time value
- java.sql.Time is the time without any date value
- java.sql.Timestamp is both the date and time

[Jamie Wool]

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.