Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

receive date of format dd.mm.yyyy HH24:MI

I'm going through a displayed table (inn Oracle Forms 10g) 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 ?
[525 byte] By [hudo] at [2007-11-11 6:58:43]