copy date into text_item 1

[hudo]

I'd like to copy the date/contents of a text_item (typ: Date ,length 19, format mask: dd.mm.yyyy HH24:MI )
into another text_item ( typ: Date ,length 19, format mask: dd.mm.yyyy HH24:MI )

Used a WHEN-BUTTON-PRESSED Trigger with:

:MY_BLOCK.MY_NEW_TIMEFIELD := TO_DATEREF_BLOCK.REF_TIME,'dd.mm.yyyy HH24:MI' );

But the hours and minutes are always 00:00

I'd like to have the real hour and minute values in the :MY_BLOCK.MY_NEW_TIMEFIELD

Please Help

 

[BJCooperIT]

MY_BLOCK.MY_NEW_TIMEFIELD must be specified as a datetime item. It sounds as though it is defined as date.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Systems Project Analyst/Custom Forms & PL/SQL - Oracle/Windows

 

[danmul]

Use to_char instead of to_date.