Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Date/Time Calculations
Date columns also keep the time. You just have to use a mask when
inserting, updanting or selecting from that column.
"Duncan Chilvers" <duncanc_at_ukf.net> wrote in message
news:3831ee70.0_at_news2.cluster1.telinco.net...
> Does anyone know of a way to calculate the difference in seconds or
minutes
> between 2 date columns?
>
> I have looked through all the functions, but the smallest time granularity
> that seems possible is a day. Can I get at anything smaller?
>
>
>
>
Received on Wed Nov 17 1999 - 04:48:15 CST