Add this function in date column
ADD_MONTHS(TO_DATE(SYSDATE),1)
Search found 2 matches
- Thu May 12, 2011 6:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to add 1 month to date
- Replies: 3
- Views: 3333
- Thu May 12, 2011 6:24 am
- Forum: General
- Topic: Job Status Message
- Replies: 7
- Views: 5904