OraFAQ Forum: Forms » System current_datetime (merged threads)

Home » Developer & Programmer » Forms » System current_datetime (merged threads)

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

System current_datetime (merged threads) [message #129942]

Wed, 27 July 2005 06:48

prase_pk
Messages: 40
Registered: July 2005
Location: india

Member

To get the date and time I am using this
System.current_datetime.

I want to use only date in a text item and I dont want time.
I did it by using substr of that till the date and am displaying that string.Is there any better way out?

Report message to a moderator

System.current_datetime [message #129943 is a reply to message #129942]

Wed, 27 July 2005 06:50

prase_pk
Messages: 40
Registered: July 2005
Location: india

Member

Report message to a moderator

Re: System.current_datetime [message #129949 is a reply to message #129942]

Wed, 27 July 2005 07:25

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
create a text item in forms (datatype is date).
When-New-Form-Instance trigger:

:BLOCK_NAME.item_name := SYSDATE;

Regards

[Updated on: Wed, 27 July 2005 07:26]

Report message to a moderator

Re: System.current_datetime [message #130042 is a reply to message #129942]

Wed, 27 July 2005 18:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Use the to_date facility with a 'DD-MON-YYYY' mask, or whichever combination of 'D' for day, 'M' for month, 'Y' for year. The documentation is fairly clear on all this.

David

Report message to a moderator