Skip to Main Content

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!

Urgent: Form not showing Time component of the sysdate

414356Feb 6 2004 — edited Feb 24 2005
When i click insert-record push button, I need to display the sysdate( date and time) in a text field. I have written this code in the when_button_pressed trigger:

Select sysdate into :BLOCKNAME.ITEMNAME FROM DUAL;

In the property pallette of the test item, i have given data type=DATE
LENGTH: 30
FORMAT MASK: DD-MON-YYYY HH24:MI:SS.

I am able to capture date but not the time component with this method. I have very less time to solve this error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2005
Added on Feb 6 2004
3 comments
288 views