• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP and Access - Date function problems

 
Hemavathy Viswanathan
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65342
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So what's the question?
 
Hemavathy Viswanathan
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
continued....



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

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

Thanks,
Hema
 
Ramaswamy Srinivasan
Ranch Hand
Posts: 295
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic