Re: 6781 DATE Formatting with Oracle Developer

Sorry, should be (86399/86400)

M

Mark Gumbs wrote in message <36f900e4.0_at_145.227.194.253>...
>How about writing a trigger (when-validate-item) to trunc the sysdate (to
>take off the time element) and add a figure which corresponds to 1 second
>less than a day?
>
>e.g
> select sysdate + (86339/86400)
> into :control.new_date
> from dual;
>
>I think this will help :-)
>
>Mark
>
>------------------------------------------------------------
>
>kevinr75_at_my-dejanews.com wrote in message
><7daq1m$21n$1_at_nnrp1.dejanews.com>...
>>Hello
>>
>>I am using Oracle forms 5.
>>
>>I am trying to accomplish the following effect.
>>
>>I want my users to enter date in format MM/DD/YYYY. This I set in the
>format
>>mask in the property palette of the text item.
>>
>>However when a record is saved or updated I want to add to the date that a
>>preset time '23:59:59'.
>>
>>So if the user enters 12/19/1974, I want the database to store 12/19/1975
>>23:59:59
>>
>>I know I can do this at the database level with insert and update trigger
>but
>>is there anyway to do this with oracle forms.
>>
>>Any ideas.
>>
>>Thanks
>>
>>-----------== 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:24:07 CET