Re: DATE (time) problem

Hi,

[Quoted] It would appear that your Item's Data Type is 'Date', but you need to use 'Datetime' to avoid time truncation.
[Quoted] [Quoted] 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
Received on Wed Sep 15 1999 - 06:27:29 CEST