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."
subject: Record selection based on current month and year