Unanswered: receive date of format dd.mm.yyyy HH24:MI
I'm going through a displayed table with a loop.
I'm using YSTEM.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 change from type DATE to type DATETIME solved my problem.
Although the type DATE in conjunction with the initial format mask dd.mm.yyyy HH24:MIS displays in forms the date part and the hour part correctly,
if I tried to export this value, respectively append it to mystring, the hour part is constantly set to 00:00:00
After changing the type to DATETIME, the export worked as I liked it.