How to extract current month and year's records alone

[Ramesh Lakshmanan]

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 ar are current month and year.
Looking forward your reply.
thanks
Ramesh

[Michael Zalewski]

Check out the TO_CHAR function

SELECT TO_CHAR( tstamp, 'MON-YYYY') ...  

[Michael Zalewski]

Actually, if you want to just retrieve all the rows where tstamp is in a particular month, it's pretty easy. For example, to retrieve everything from December 2002 through February 2003, just use

SELECT * FROM MyTable
  WHERE tstamp >= '1-DEC-2002'
    AND tstamp < '1-MAR-2003'

[Ramesh Lakshmanan]

Hi Guys,
I got the solution.

I think we can use any of the following.Both gave correct result for me.
1> select tskid from TASKTBL where tstamp >= trunc(sysdate,'MM')2> select tskid from TASKTBL where to_char(tstamp,'MON-YYYY') = to_char(sysdate,'MON-YYYY')

thanks
Ramesh