Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date/Time Calculations

Re: Date/Time Calculations

From: Screamer <mflopes_at_bigfoot.com>
Date: Wed, 17 Nov 1999 10:48:15 -0000
Message-ID: <80u1c2$k9h$1@duke.telepac.pt>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US