You have two options:
you can change the select from 'select datecol' to 'select to_char(datecol,
'YYYYMMDD HH24MISS')'.
or you can bind the date-column to a date-variable (a 7 byte structure i
believe). the oci docs show you how this structure is set-up (if you have
trouble mail me at
gert @ albertheijn . nl for some sample-code).
--
reply address is altered to keep the spam down
remove the nospamplease part to reply...
henry.vandeligt_at_visy.com.au wrote in article
<886727073.577241090_at_dejanews.com>...
> I have an application that obtains DATE (including TIME) data from ORACLE
> V7.3 using C++ and OCI. Problem is that I loose the TIME component. OCI
> documentation gives Internal Data Types of DATE and External Data Type of
> VARCHAR2 and DATE. Both return only the DATE portion. How do I Obtain
> TIME info? The application is generic and needs to be able to read a wide
> variety of tables with the attribute contents only knoweable at execution
> time. Any help please?
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Sat Feb 07 1998 - 00:00:00 CST
