Win a copy of Mesos in Action this week in the Cloud/Virtualizaton 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
  • 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
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic