| Execute Package Error [message #73167] |
Tue, 24 February 2004 14:41 |
Lee Yoke Ping
Messages: 2
Registered: February 2004
|
Junior Member |
|
|
I try to execute the package where i try to delete last month data. In the "Execute SQL Task Properties" I have this select statement -
delete from [[AUS]].[[dbo]].[[aus007tbl]] where yyyymm = to_char(add_months((sysdate), -1), 'YYYYMM')
After execute package, system return with error message - "add_months" is not a recognized function name.
Please advice what is the proper function to get last month.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
