Oracle & VB6 date/time

From: Travis Powell <thedogs_at_mindspring.com>
Date: Thu, 17 Dec 1998 16:34:05 -0500
Message-ID: <367978CD.E3340FEB@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 Thu Dec 17 1998 - 15:34:05 CST