This may be an Oracle question, but I am using Visual Basic 6.0 Ent. Ed.
with Crystal Report 6.0. I am building a query to retrive records from
Oracle using a date/time stamp.

tStr = "{FINISH} >= DateTime(" & gFromYear & "," & gFromMonth & "," &
gFromDay

tStr = tStr & "," & gFromHours & "," & gFromMinutes & "," & gFromSeconds
& ")  AND {FINISH} <= DateTime(" & gToYear & "," & gToMonth & ","

tStr = tStr & gToDay & "," & gToHours & "," & gToMinutes & "," &
gToSeconds & ")"

ImpactCRW.CrystalReport1.SelectionFormula = tStr

If I run the query using a from time of 00:00:00, I get everything. If I
use a time of 08:00:00 for example, I do not get any information. I am
not using ODBC to retrieve this information. If I run Oracle ODBC test,
the date/time does show up, but if I use Oracle's SQL Plus the time does
not.

Is there a control for Crystal Reports, or a Visual Basic method, that I
can use to get the correct time from the database?

Thanks.
--

======================
Travis Powell