Re: OCI Question: Date, Time ....
From: Henri M.B. van den Bulk <hvdbulk_at_lgc.com>
Date: 1996/06/07
Message-ID: <31B83CEA.6201_at_lgc.com>#1/1
Date: 1996/06/07
Message-ID: <31B83CEA.6201_at_lgc.com>#1/1
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.htmlReceived on Fri Jun 07 1996 - 00:00:00 CEST