Page 1 of 1
i want to add a date column with 180 days
Posted: Fri Nov 14, 2008 1:02 am
by seshikumar
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.
Posted: Fri Nov 14, 2008 1:17 am
by Romy
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
thanks Romy ..........
Posted: Fri Nov 14, 2008 5:37 am
by seshikumar
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
Posted: Fri Nov 14, 2008 8:56 am
by ray.wurlod
Please mark this thread as Resolved using the green button at top.