Re: OCI Question: Date, Time ....

Tingting Xu wrote:
>
> Hi,
>
> I am having big trouble in getting a way to manipulate
> the DATE type through OCI. When an application needs to get the Time
> portion from a column which is a date type, and the NLS_DATE_FORMAT
> is defaulted to DD-MON-YY. I cannot find a way to do this
> through OCI.
>
> Can anyone give me some advice on this?
>
> I greatly appricate your help.
>
> Tingting Xu (txu_at_softart.com)

What you need to do is encapsulate the select with the to_char function:

select to_char(<date-column>, 'HH24:MI:SS') from WHATEVER;

So if you detect in you OCI layer that your application want the time, then do the above.

Hope this helps.

-- 
 Henri M.B. van den Bulk                http://tulsix.utulsa.edu/~hvdbulk/
 Landmark Graphics Corp.,               http://www.lgc.com
 Drilling & Well Services Product Group http://www.tcel.com/~mgi/drill.html