Hi all,
Please advise me how to add one month to current date.
Please let me know if there is any function.
We are using Datastage 7.1 server
Os windows xp.
DB oracle
Thanks in advance
Adding month to current date
Moderators: chulett, rschirm, roy
Define one month. If today is 2007-01-31, do you expect 2007-02-28? If it's 2007-02-28, do you expect 2007-03-31? You need to be very clear. Simply incrementing the month and potentially the year doesn't handle the varying days in a month. You need to be clear on "date rounding".
Otherwise, there's functions already posted on ths forum to do almost exactly what you're asking. Use the Search facility.
Otherwise, there's functions already posted on ths forum to do almost exactly what you're asking. Use the Search facility.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Please help me
I am not getting any page. Could you please give me the copy of that routineDSguru2B wrote:Nothing out of the box. You can click on Ray's footer that will take you to his page. He has a routine that will solve your problem.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: