Re To MARK GUMBS: Getting DB time from Forms 5.0

From: <mcotter_at_my-dejanews.com>
Date: Thu, 25 Mar 1999 17:33:09 GMT
Message-ID: <7dds0l$p6n$1_at_nnrp1.dejanews.com>


Mark,

[Quoted] Thanks for the response, however it does and yet doesn't work.....I format the [Quoted] date fine, basically I do a to_date(to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss')) [Quoted] because I'm inserting into a date field. However, I still only get 00:00:00 in [Quoted] my time stamp. I want the actually time that the record is posted/updated to [Quoted] the database. More help would be greatly appreciated.

Michael

In article <36f8fd0a.0_at_145.227.194.253>,   "Mark Gumbs" <mgumbs_at_hotmail.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 25 1999 - 18:33:09 CET

Original text of this message