Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JSP and Access - Date function problems  RSS feed

 
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
Posts: 65891
135
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.

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!