Re: DATE (time) problem

[Quoted] it is a forms data type.

daud11_at_hotmail.com schrieb:

> Hi
>
> Is datetime a data type in Oracle 7.3? I dont seem to be able to find
> 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/
> Share what you know. Learn what you don't.
Received on Wed Sep 15 1999 - 19:42:20 CEST