Oracle Forms (MOSC)

MOSC Banner

COPY BuiltIn truncates TIME portion of a DATE value

edited Mar 20, 2012 5:03PM in Oracle Forms (MOSC) 4 commentsAnswered
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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center