File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Query to sort the date by month and year udint the date format in MS Acess

 
Amit Roy
Ranch Hand
Posts: 132
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello Frns
I am trying to retrive data from MS Acess databse by Date. My date field is in the following format in my table (MM/DD/YY) i want to sort the records based on year and month ie i want to use the date and year in my WHERE clause does ne 1 know to do this i have to use the date format that is already present kindly help
URGENT
Amit
 
Frank Carver
Sheriff
Posts: 6920
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a database question rather than one about servlets and JSP, so I've moved it to the JDBC forum.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic