i want to add a date column with 180 days

[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.

[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

[seshikumar]

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

[ray.wurlod]

Please mark this thread as Resolved using the green button at top.