Re: ODBC Date/Time Problem

From: Rognvald Bjarne <wear_u_out_at_nospam.hotmail.com>
Date: 2000/08/10
Message-ID: <KVCk5.8934$KFL5.95486067@news.randori.com>#1/1

"Seajay" <seajaysNOseSPAM_at_hotmail.com.invalid> wrote in message news:09c4ca10.b6f9d0e8_at_usw-ex0106-045.remarq.com...
> 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?

Could be the NLS_DATE_FORMAT parm for the db instance;

try to_date(<column_name>,'yyyy-mm-dd hh:mm:ss') and see if it comes up all zeroes after the dd. Received on Thu Aug 10 2000 - 00:00:00 CDT