How can I query records that are only within the last year using sysdate?
Posted on 2008-06-24
I have a field invoice_date that is a DATE field. I want to be able to select all rows from the table invoice to show customers who have had an invoice within the last 12 months using sysdate. How can this be done?