I am using a PL/SQL script to extract data and I am currently using,
The second month is the current month and the starting month is last month. Can this be coded to automatically generate the dates?
Code:
and I.MATCH_DATE >= to_date('09/01/2011', 'MM/DD/YYYY')
and I.MATCH_DATE < to_date('10/01/2011', 'MM/DD/YYYY')
The second month is the current month and the starting month is last month. Can this be coded to automatically generate the dates?