Re: comparing times with Oracle?

Try SUBTRACTION.

Daniel Morgan

NoNice Guy wrote:

> 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 - 03:55:16 CST