I have a date column in source table, I am using 7.5 A server jobs - i want to add 180 days to the source date.
Please advise me how to use it for my requirement.
i want to add a date column with 180 days
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 44
- Joined: Fri Mar 16, 2007 5:51 am
-
- Participant
- Posts: 44
- Joined: Fri Mar 16, 2007 5:51 am
thanks Romy ..........
Romy wrote:Hi,
First convert the input date column to internal date using the iconv function. It will return a number. Then add 180 to this internal date and using oconv function convert it to the external date format.
Hope this will help you.
Thanks.
Romy
seshu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: