Hi,
I need to copy data from my_table by identifying the records with column date_col01. date_col01 is the LAST DAY for every month (a date column)
For example....on the 4th of the present month, copy records that came in on the LAST DAY of last month (identified by date_col01)
P/S
I don't want to hard code the date because this is a job to be setup to run every month (present month) looking back at the previous month.
Thanks