• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to extract current month and year's records alone

 
Ramesh Lakshmanan
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out the TO_CHAR function
 
Michael Zalewski
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ramesh Lakshmanan
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic