> Is there any function which works to add two dates or add a day to the date?
> If anybody has any idea, share that with me!!!
Adding two dates is meaningless. You can add an interval to a date and
get another date (e.g. 2001-04-22 plus 1 day = 2001-04-23), or you can
substract one date from another and get an interval (e.g. 2001-04-23
minus 2001-04-22 = 1 day).
How are you storing your dates and intervals? In Unix you typically
store dates as seconds since 1-1-1970, and you store intervals as
seconds. In Oracle, you store dates using the date type and you store
intervals as a (possibly fractional) number of days.
