Re: Date calculation function

Randy Harris wrote:
<snip>

> Frank, am I interpreting this correctly? If I add an integer to a
date, it
> assumes I am adding days and returns the date offset by that many
days?

Yes. An integer of 1 means you are adding 1 day i.e. 24 hours to the date. e.g.
select sysdate + 1 from dual; will return same time tomorrow.

You can also use fraction of 1 to add e.g. hours, minutes, seconds etc. e.g.
select sysdate + (1/24) from dual; will add 1 hour. select sysdate + (1/1440) from dual; will add 1 minute.

Regards
/Rauf Received on Wed Jan 12 2005 - 11:26:29 CST