Timestamp and sql

nevada city · June 24th, 2003, 05:02 PM

I did
String myoldts = new String("2003-05-23 18:19:20");
Timestamp myts = new Timestamp(0L);
myts.valueOf(myoldts);

System.out.println(myts.toString());

1969-12-31 19:00:00.0

How can I convert a String with a SQL timestamp to write to a sql database ?

gigsvoo · June 24th, 2003, 09:11 PM

It depends on what format does your DB supports or used to store date value. E.g. for DB/2, the default date format is MM/DD/YYYY so the way to format your data would need a use of SimpleDateFormat() and use a Calendar() object to set the date and time to convert to the proper format.

Look at the following Calendar to DB/2 date format function of mine:

Code:

public final String SQLCalFieldFormat(Object value) {

        if ((value != null)
            && ((value.getClass().equals(GregorianCalendar.class)
                || (value.getClass().equals(Calendar.class))))) {
            Calendar nv = (Calendar) value;
            SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy");
            return "'" + formatter.format(nv.getTime()) + "'";

        } else {
            return "NULL";
        }
}

Hope this helps!

Neo Gigs

Thanks

Neo Gigs

nevada city · June 24th, 2003, 10:06 PM

Thanks for the info, I am using or trying to use firstsql (1% java database)

However any idea why I got 1969 ?

Thanks

gigsvoo · June 24th, 2003, 11:20 PM

Dun use TimeStamp. use a Calendar object to set the date you wanto hold and stores it into DB. Check doc API for the proper definition and limitation of using TimeStamp.

Thanks

Neo Gigs