REPOST: 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
> >

• WAS CANCELLED BY =======: From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C512B84.8422DB73_at_exesolutions.com> Subject: cmsg cancel <3C512B84.8422DB73_at_exesolutions.com> Date: Mon, 28 Jan 2002 02:15:15 GMT Message-ID: <cancel.3C512B84.8422DB73_at_exesolutions.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!fu-berlin.de!nntp.infostrada.it!news.mailgate.org!news2.euro.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716241

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 03:55:16 CST