SQL Query to sort the date by month and year udint the date format in MS Acess
Joined: Oct 10, 2000
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
<I>Chance Favours the Prepared minds"</I>
Joined: Jan 07, 1999
This is a database question rather than one about servlets and JSP, so I've moved it to the JDBC forum.