This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes Servlets and the fly likes SQL Query to sort the date by month and year udint the date format in MS Acess Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Java » Servlets
Reply Bookmark "SQL Query to sort the date by month and year udint the date format in MS Acess" Watch "SQL Query to sort the date by month and year udint the date format in MS Acess" New topic
Author

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

Amit Roy
Ranch Hand

Joined: Oct 10, 2000
Posts: 132
posted
0
Quote
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>
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6919
posted private message
0
Quote
This is a database question rather than one about servlets and JSP, so I've moved it to the JDBC forum.

Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: SQL Query to sort the date by month and year udint the date format in MS Acess
 
Similar Threads
How to use the year-from-dateTime function
Collision of Date format between java.sql and SQL Server
Date functions
SQL Query to sort the date by month and year udint the date format in MS Acess
How to convert java.util.Calendar in JSTL?