Re: FORMS Block DATE Item not storing time
Date: Fri, 5 Mar 1999 13:16:20 +0100
Message-ID: <7boi5t$1io$1_at_nickel.uunet.be>
The item must be of type Datetime
wssimtw_at_my-dejanews.com wrote in message
<7bn8vg$eea$1_at_nnrp1.dejanews.com>...
>I am using Forms 4.5 with Oracle 7.3. If I have a DATE Block item and I try
to
>store a value in it using the TO_DATE(...,'MON DD,YYYY HH:MI AM') built-in
>function, for some reason it always sets the time to 12:00 AM. If I set a
>PL/SQL DATE variable to the same TO_DATE function and then perform an:
>
> UPDATE table set column = PL/SQL DATE variable
>
>and then re-query the database, the Block Item then contains the correct
>value. How can I set the time for a BLOCK DATE Item without updating and
>re-quering the database?
>
>Mark
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 05 1999 - 13:16:20 CET