Re: Getting DB time from Forms 5.0
From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Thu, 25 Mar 1999 10:06:48 +0800
Message-ID: <36F99A38.C6920051_at_ccis.adisys.com.au>
Date: Thu, 25 Mar 1999 10:06:48 +0800
Message-ID: <36F99A38.C6920051_at_ccis.adisys.com.au>
mcotter_at_my-dejanews.com wrote:
> Having trouble stamping to the database the server time when using SYSDATE in
> a froms date item.....ie. :my_block.date_item := sydate; only puts the date
> to the database column, and not the time. Have looked at the $$DBDATETIME$$
> but it seems like an aweful lot of trouble...anyone have suggestiongs??
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Define your item as DATETIME rather than DATE. It will then include the time component from sysdate.
Geoff Received on Thu Mar 25 1999 - 03:06:48 CET