FORMS Block DATE Item not storing time
From: <wssimtw_at_my-dejanews.com>
Date: Fri, 05 Mar 1999 00:37:05 GMT
Message-ID: <7bn8vg$eea$1_at_nnrp1.dejanews.com>
[Quoted] I am using Forms 4.5 with Oracle 7.3. If I have a DATE Block item and I try to [Quoted] 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:
Date: Fri, 05 Mar 1999 00:37:05 GMT
Message-ID: <7bn8vg$eea$1_at_nnrp1.dejanews.com>
[Quoted] I am using Forms 4.5 with Oracle 7.3. If I have a DATE Block item and I try to [Quoted] 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 - 01:37:05 CET