Oracle date/time retrieval

From: Travis Powell <thedogs_at_mindspring.com>
Date: Tue, 15 Dec 1998 13:11:28 -0500
Message-ID: <3676A650.FA1A9D44_at_mindspring.com>

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.

How can I get the correct date/time without using ODBC?

Thanks.

-- 

======================
Travis Powell
thedogs_at_mindspring.com

Received on Tue Dec 15 1998 - 19:11:28 CET