OraFAQ Forum: Forms » todays date and current time

Home » Developer & Programmer » Forms » todays date and current time (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

todays date and current time [message #174920]

Wed, 31 May 2006 00:59

rakas22
Messages: 29
Registered: May 2006

Junior Member

hi all,

i want to have todays date and running time in my forms when new_form_instance.

please help me

Report message to a moderator

Re: todays date and current time [message #174921 is a reply to message #174920]

Wed, 31 May 2006 01:02

karuparamb
Messages: 13
Registered: December 2005
Location: Jeddah

Junior Member

You can use
select sysdate, to_char(sysdate,'HH:MI:SS') time from dual;

By
Abdul Aziz

Report message to a moderator

Re: todays date and current time [message #174925 is a reply to message #174921]

Wed, 31 May 2006 01:05

rakas22
Messages: 29
Registered: May 2006

Junior Member

please help me with the use of timer object

Report message to a moderator

Re: todays date and current time [message #174926 is a reply to message #174925]

Wed, 31 May 2006 01:07

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Is this still related to the "i want to have todays date and running time in my forms when new_form_instance." or is it a new question?

MHE

Report message to a moderator

Re: todays date and current time [message #174927 is a reply to message #174926]

Wed, 31 May 2006 01:09

rakas22
Messages: 29
Registered: May 2006

Junior Member

related to new_form_instance only.

in the new_form_instance tell me how to use timer object to have running time and date in the forms

Report message to a moderator

Re: todays date and current time [message #174928 is a reply to message #174926]

Wed, 31 May 2006 01:13

karuparamb
Messages: 13
Registered: December 2005
Location: Jeddah

Junior Member

create ine ONE DISPLAY ITEM FIELD
AND DO IT AS LIKE BELOW

WHEN-NEW-FORM-INSTANCE
DECLARE
TIMER_ID TIMER;
TIMERMIN_ID NUMBER(5) := 10000;
BEGIN
TIMER_ID := CREATE_TIMER('POS_TIMER',
ONE_MINUTE,REPEAT);
END;

WHEN-TIMER-EXPIRED
DECLARE
TIME VARCHAR2(20);
BEGIN
V_TIMER :=GET_APPLICATION_PROPERTY(TIMER_NAME);
TIME := :System.Current_Datetime;
:CONTROLS.DFTIME := TO_CHAR(SYSDATE,'HH:MI AM');
END;

By
Abdul Aziz

Report message to a moderator