ODBC and Dates

I'm connecting to an Oracle 7.1 database through ODBC on a Win 3.1 machine. I am doing all of this through Visual Basic 3.0 Pro. I am having problems with the time-date field when I don't use the data control in VB. I believe the problem is with the ODBC driver and Oracle. I cannot figure out how to format the date-time to send it in an SQL call to the database (this was also a problem for me when I worked with Sybase).

What should my date-time format look like?

06/17/96 06:30:10 PM

This is what is NOT working....as well as many other combinations. I can only get it to accept it while omitting the time...but when using the data control, I can get the date and time entered (but the data control is a little slower and more complicated). It is very important for me to keep track of the time as well as the date!

--

flush_at_Radix.Net
Josh Pinkert
--
Received on Mon Jun 17 1996 - 00:00:00 CEST