ODBC Date/Time Problem

I currently send a date to a stored procedure in Oracle using the ODBC date format:

{ts '2000-08-10 12:14:00'}

Unfortunately when it 'gets there' Oracle is only storing the Date part and not the Time in the database. I've used an output parameter on the stored procedure to display exactly what the input parameter was that Oracle received and it just comes back as:

10-Aug-00

So it looks as if the time may be being lost in transfer by ODBC. Or is it? Anyone have any suggestions?

(I'm using Coldfusion Application Server, Oracle 8i, and the Microsoft ODBC drivers for Oracle - Why? Because the Oracle drivers give very weird permission errors whent trying to run stored procedures via CF and simply swapping the ODBC driver gets rid of them all - it took us about three days to find that out!)

email: seajays_at_hotmail.com
web: www.mufasa.freeserve.co.uk

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Aug 10 2000 - 00:00:00 CDT