JSP and Access - Date function problems

[Hemavathy Viswanathan]

Hi,
We are designing a JSP page and the backend is MS-Access. In Access, the date format is in SHORT format (MM/dd/yyyy). Now I need to query my access tables using the Java date objects created in the JSP. The following is the method I am trying now:

 Calendar calendar = new GregorianCalendar();
        Date date = calendar.getTime();
        DateFormat localFormat = DateFormat.getDateInstance();
   

[Bear Bibeault]

So what's the question?

[Hemavathy Viswanathan]

continued....

   
DateFormat _format = new SimpleDateFormat( "MM/dd/yyyy" );
String date_format = _format.format( date );
 

And for my access query, I am converting the string object to a date using the cdate() function.

 update table ABC set col_name=cdate(date_format) where .....   

It does not give me any error. But the cdate is returning some unambiguous dates. Can anyone please help?

Thanks,
Hema

[Ramaswamy Srinivasan]

Something like what you do, for example, the below code snippet should ideally work fine. If the returned date is not in a user-understandable format, please check the default dateformat that access uses.

 
java.util.Date myDate = new java.util.Date();
 
java.text.SimpleDateFormat format = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
 
String formattedDate = sdf.format(dt);