OraFAQ Forum: Forms » receive date of format dd.mm.yyyy HH24:MI

Home » Developer & Programmer » Forms » receive date of format dd.mm.yyyy HH24:MI

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

receive date of format dd.mm.yyyy HH24:MI [message #140704]

Wed, 05 October 2005 05:11

wucis
Messages: 60
Registered: March 2005

Member

I'm going through a displayed table with a loop.
I'm using :SYSTEM.CURRENT_VALUE to receive the value of the actual item
which is appended to the variable mystring of type VARCHAR2(1000)

If there is a date field in the table (e.g.: emp.hiredate),
(the item is in forms of type DATE with the Format Mask: dd.mm.yyyy HH24:MI ),
I receive only the date part. The hours, minutes are always set to 00

How can I hand over the correct hours, minutes to mystring ?

The form

Report message to a moderator