Urgent: Form not showing Time component of the sysdate
414356Feb 6 2004 — edited Feb 24 2005When 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.