Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Record selection based on current month and year  RSS feed

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:
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.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!