Re: newby sql question: adding time

Peter Verschueren wrote:
> how do i add a number representing total of minutes to a date: 200(minutes)
> to 24-06-03 14:00:00 would make
> 24-06-03 17:20
>
> thanks
>
> peter
>
>

ORACLE dates are in units of days, so just calculate the fraction of a day that 200minutes represents and add it. The arithmetic is left as an exercise for the student 8^)

(Final hint: it's in the manual!)

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost