D2K Forms and Date Formatting

From: Oracle Newbie <h2001_at_hotmail.com>
Date: Sun, 20 Jun 1999 23:13:40 +0100
Message-ID: <7kjp3i$gdv$1_at_lure.pipex.net>

Would be grateful if someone can help with this:

[Quoted] Trying to get date/time into a field from system date as

    :myblock.myfield := to_char( sysdate, 'DD-MM-YYYY HH24:MI:SS' );

     myfield is a database item of type date

The date part is inserted correctly but the current time is lost and get 00:00:00.

Is there a workaround to this situation or is it a software bug?

Many Thanks

Oracle Newbie, London
h2001_at_hotmail.com Received on Mon Jun 21 1999 - 00:13:40 CEST