Re: Selecting records with a date condition

From: <shiling_at_math.wayne.edu>
Date: Thu, 17 Jun 1999 02:42:21 GMT
Message-ID: <7k9nab$6so$1@nnrp1.deja.com>

The trunc function may help.

where trunc(to_date(logintime,'dd-MON-yyyy'))= '14-JUN-1999'

In article <3767f4e4_at_news2.one.net>,
"David" <davidbr93_at_hotmail.com> wrote:
> I'm having problems retrieving data from an Oracle database
> using the OLE control provided with Oracle. The problem involves
> passing a date to retrieve Oracle records from Visual Basic. When I
try to
> retrieve all records for a particular date, as in the statement
"Select *
> from Logtable where logintime = '14-JUN-1999'", I get no records
> returned. If I change the = to <=, I get records from the 13th down
> but still no 14th. I'm thinking the = condition is failing becuase of
> some type of timestamp needed.
> Thanks!
> Dave B.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 16 1999 - 21:42:21 CDT