Re: Re To MARK GUMBS: Getting DB time from Forms 5.0

Try defining the field as datetime and see what happens.

Mark

mcotter_at_my-dejanews.com wrote in message <7dds0l$p6n$1_at_nnrp1.dejanews.com>...
>Mark,
>
>Thanks for the response, however it does and yet doesn't work.....I format
the
>date fine, basically I do a to_date(to_char(sysdate, 'mm/dd/yyyy
hh24:mi:ss'))
>because I'm inserting into a date field. However, I still only get 00:00:00
in
>my time stamp. I want the actually time that the record is posted/updated
to
>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 Fri Mar 26 1999 - 16:01:25 CET