Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Selecting records with a date condition
please try in where to_date(logintime)
David 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.
Received on Sun Jun 20 1999 - 21:11:31 CDT