Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DATE/time - adding minutes
In article <7v78dq$7h2$1_at_bagan.srce.hr>, "keso" <keso_at_hep.tel.fer.hr>
wrote:
> What is the simplest method of calculating DATE that is e.g. 15
> minutes
> after specified DATE/time?
> Is it really necessary to write function similar to ADD_MONTHS:
> FUNCTION ADD_MINUTES (d DATE, mi number) return DATE is /* d = d
> + mi */
> ....
> thanks,
> Vedran
When you add something to a date, you add days, so if you use 1/24/60*mins you get the fraction of day to add