Re: DATE (time) problem

Hi

[Quoted] Is datetime a data type in Oracle 7.3? I dont seem to be able to find [Quoted] it in my doc.

Daud

In article <7rn78c$fuc10_at_atbhp.corpmel.bhp.com.au>,   "Neville Sweet" <sweet.neville.nj_at_bhp.com.au.no_junk_email> wrote:
> Hi,
>
> It would appear that your Item's Data Type is 'Date', but you need to
use
> 'Datetime' to avoid time truncation.
> Change TRX_TIME to Datetime and simply use :BASE_TABLE.TRX_TIME :=
SYSDATE;
>
> >I have a form (built using D2K r2.1) that is used to enter records
into
> >a base table which has a DATE column. In my form, I have a WHEN-
CREATE-
> >RECORD trigger which has this code:
> >
> >:BASE_TABLE.TRX_TIME := TO_DATE(TO_CHAR(SYSDATE, 'DD-MON-YYYY
HH:MI:SS
> >AM'), 'DD-MON-YYYY HH:MI:SS AM');
> >
> >When a new record is created the date that appears is correct but the
> >time is 'XX-XXX-XXXX 12:00:00 AM'. I thought it should be the
"current"
> >time because of the trigger above. Why is that?
> >I have also tried the statement below but still the same result.
> >
> >:BASE_TABLE.TRX_TIME := SYSDATE;
> >
> >I also have a format mask for that date/time column: 'FMFXDD-MON-YYYY
> >HH:MI:SS AM'. I dont think that this format mask is causing the
problem.
> >
> >Regards
> >Daud
>
>

Sent via Deja.com http://www.deja.com/
[Quoted] Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 13:50:30 CEST