COPY BuiltIn truncates TIME portion of a DATE value
I am trying to set a timestamp (in a PRE-UPDATE trigger) of a dynamically built form item by:
v_TimestampValue := sysdate;
COPY(v_TimestampValue, NAME_IN(dynamic_DATE_TYPE_ITEM_name)
where v_TimestampValue is declared as datatype DATE
and the forms item named by the content of dynamic_DATE_TYPE_ITEM_name is set to type DATE also.
I have proved that the time portion of the v_TimestampValue is preserved up to the COPY builtin.
When I check the value in the database after the update is committed, the date is a TRUNC(date) with no time portion (well, time is 00:00:00).
v_TimestampValue := sysdate;
COPY(v_TimestampValue, NAME_IN(dynamic_DATE_TYPE_ITEM_name)
where v_TimestampValue is declared as datatype DATE
and the forms item named by the content of dynamic_DATE_TYPE_ITEM_name is set to type DATE also.
I have proved that the time portion of the v_TimestampValue is preserved up to the COPY builtin.
When I check the value in the database after the update is committed, the date is a TRUNC(date) with no time portion (well, time is 00:00:00).
0