Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Selecting Date in iReports

964359Sep 25 2012 — edited Sep 27 2012
hello..
the part of my query in ireport for selecting the date range is
tran_date BETWEEN (select trunc(sysdate,'year') from dual) AND (select last_day(trunc(sysdate,'month')-1) from dual)
and when i run this in january every year, the year value is not decrementing in second select statement.
can anyone help me out...!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2012
Added on Sep 25 2012
#plsql, #reports, #sql
5 comments
625 views