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!
select * from payments where to_char(paydate,'mm')=05; here is my query with month but also need it with year.