Mapping Java Date to an Oracle Date.

[Tony Evans]

I get todays date from my java application and add it to my Oracle Database.
I need to add the date in the format '31-OCT-02'
the only string in this format is using the date method toGMTString() toGMTString()
'31-OCT-2002 14:41:24 GMT'
I can parse this string to translate it into the Oracle format, but I wonder is there a more efficient manner.
Cheers for any help Tony

[Tony Evans]

Also how do I add 5 days to a date, I have looked at the Date Class, and i cannot see any methods that will allow me to do this.
Cheers Tony

[Tony Evans]

Worked out the solution to the second problem.
Calendar c = new GregorianCalendar();
Date d = c.getTime();
System.out.println("CreateCustomerOrder : service() : ToDays Date "+d.toGMTString());
c.add(Calendar.DATE,5);
d = c.getTime();
System.out.println("CreateCustomerOrder : service() : Future Date "+d.toGMTString());

System.out.println("CreateCustomerOrder : service() : Get CustomerOrderID");
Tony

[prabhat kumar]

for converting to sql.Date type

  
public java.sql.Date prepareSQLDate(String dateIn){
        //String dateIn = "12.15.2001";
        String formatIn = "dd.MM.yyyy";  // format of incoming string
        //parse the date using java.util.Date classes
        ParsePosition pp = new ParsePosition(0);
        SimpleDateFormat sdfi = new SimpleDateFormat(formatIn);
        java.util.Date date = sdfi.parse(dateIn,pp);
        if( date == null )
                throw new RuntimeException( "Unparsable date: "+dateIn);
        //convert a java.util.Date to a java.sql.Date
        java.sql.Date sqlFromLong = new java.sql.Date(date.getTime());
        //output is: 2001-01-01
        logger.info("sqlFromLong (java.sql.Date): "+sqlFromLong);   
        return sqlFromLong;
    }

[Leslie Chaim]

I would give the work to Oracle
First of all, in Oracle if you insert into a DATE column, and your date literal is in the default data format (which is usually DD-MON-YY) then you can simply send the string to Oracle like this:

insert into table
(date_column)
values
('31-oct-02');

Second, you can use Oracle's to_date function:

insert into table
(date_column)
values
(to_date('023110', 'YYDDMM'));

Yes the above is a bit crazy with the YYDDMM, but the point is made
Third, to add 5 days why not give it to Oracle?

insert into table
(date_column)
values
(to_date('023110', 'YYDDMM') + 5);