aspose 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
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