Sounds like you need to use a combination of ADD_MONTHS and LAST_DAY functions. Something like LAST_DAY(ADD_MONTHS(date_col1,-1))
Sergey
|
Results 1 to 7 of 7
Thread: help with date (function) sql
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote