Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYSDATE

Amatu Allah Neveen EbrahimAug 2 2008 — edited Aug 3 2008

Forms 10G
----------------

date and time are date datatype
------------------------------------------------
In when-New-Form-Instance Trigger :
--------------------------------------------------------
:DATE_IN := SYSDATE; --works fine
But,
:TIME_IN := TO_DATE(TO_CHAR(SYSDATE,'HH:MI:SS'),'HH:MI:SS');

Returns 12:00:00 which is not correct i want the current record the cursor is in returns the current time of the sysdate
How Could i do that..?
------------------------------------------------------------

Best Regards,
Abdetu..

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2008

Added on Aug 2 2008

#forms, #moved-from-devops

11 comments

1,580 views