logic for updating date

chandiwalachintan · Post by **chandiwalachintan** » Sat Apr 07, 2007 10:42 am

I have an input column date datatype and it contains either 1st day of month or last day of month, i need to develop logic such that last day of month should be increased by one day and it becomes first day of next month and keep first day of months as it is.
Thanx

chulett · Post by **chulett** » Sat Apr 07, 2007 10:55 am

There are functions available to handle 'Julian' dates. Use them to convert your 'last day of the month' to julian format, add 1 to that date (which will add 1 day) and then convert it back to an external date.

DSguru2B · Post by **DSguru2B** » Sat Apr 07, 2007 11:43 am

Check the day part with if then else and if its not '01' then convert to ordinal date using JulianDateFrom() function (I think thats what its called) to convert it and do as Craig advised.

chandiwalachintan · Post by **chandiwalachintan** » Sat Apr 07, 2007 12:06 pm

thank you very much

ivannavi · Post by **ivannavi** » Mon Apr 09, 2007 3:31 am

If you are selecting from Oracle, then I think I can help you...

ray.wurlod · Post by **ray.wurlod** » Mon Apr 09, 2007 2:46 pm

So could many of us. But there was nothing in the original post to suggest Oracle. You may be surprised to learn that not everyone in the world uses Larry's database.

A universally-applicable solution was required, and given.