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: comparing times with Oracle?

Re: comparing times with Oracle?

From: NoNice Guy <harry_p_hood_at_yahoo.com>
Date: Fri, 25 Jan 2002 09:12:35 -0600
Message-ID: <3c51772a$1@MAIL.mhogaming.com>


I am simply using 1 field for date/time since oracle has both in that one datatype. But there is no built in staement for comparing times.. just dates right?

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:3C508F65.6CE8FCAB_at_exesolutions.com...
> You could insert the date of the transaction as Oracle date fields contain
the
> time.
>
> Daniel Morgan
>
>
>
>
> NoNice Guy wrote:
>
> > Hey there! I'm trying to write a program that reads records from a
database.
> > Many programs update their corresponding record when they complete a
> > transaction. What I'd like to do with the program is check the time to
make
> > sure that it happened within the last 30 minutes. Does anyone know how
this
> > could work? Thanks in advance! By the way, I am using OCI, and C on
Linux.
> > Thanks!
> >
> > Jon
>
Received on Fri Jan 25 2002 - 09:12:35 CST

Original text of this message

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