Re: Getting DB time from Forms 5.0

If you format the field as date then only the date is commited to the database. Set the
property to datetime.
Günter

Geoff White schrieb:

> 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 Fri Mar 26 1999 - 15:15:00 CET