Re: Getting DB time from Forms 5.0

[Quoted] You have to extract the time element from sysdate yourself.

e.g

select to_char(sysdate, 'HH:MI:SS')
into :control.time
from dual;

HTH Mark

mcotter_at_my-dejanews.com wrote in message <7dassf$4ke$1_at_nnrp1.dejanews.com>...
>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
Received on Wed Mar 24 1999 - 16:03:09 CET