Re: 6781 DATE Formatting with Oracle Developer

[Quoted] 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:19:42 CET