Re: DATE (time) problem

Problem solved.....thank you guys.

Daud

In article <37DFDA7C.A9AD94D2_at_t-online.de>,   Guenter Huerkamp <guenter-huerkamp_at_t-online.de> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 16 1999 - 01:55:25 CEST