File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Record selection based on current month and year Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Record selection based on current month and year" Watch "Record selection based on current month and year" New topic
Author

Record selection based on current month and year

Ramesh Lakshmanan
Greenhorn

Joined: Oct 14, 2002
Posts: 21
Hi All,
Can anyone let me know , how to fetch the current month and years records alone from an Table.(my database is Oracle).

Here are the sample of records:
TSKID TSTAMP
T1 20-MAR-2002
T2 21-JAN-2003
T3 22-MAR-2001
T4 23-APR-2003
T5 12-MAR-2001
T6 27-MAR-2000
T7 12-MAR-2002
T8 09-APR-2003
T9 08-APR-2003
T10 22-MAR-2003
T11 23-MAR-2003
T12 24-JAN-2003
so i want to take all the TSKID where TSTAMP is current month and year.
Looking forward your reply.
thanks
Ramesh


SCJP1.2,SCWCD<br />SAP/J2EE Consultant<p><br />"Plan for the Work and Work for the Plan."
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Record selection based on current month and year
 
Similar Threads
how to display all months of a particular year according to the following rule
setting default value for a combobox
Using SpringSource's Jasper within OSGi (moving from Spring Web Extender to HTTP Service)
How to extract current month and year's records alone
Drop down menu selection trouble