Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Date/Time Trigger Problem
Thank you so mocu!
Complicated syntax, but it WORKS!
Thanks again.
Dave
In article <80obvi$13nq0$1_at_fu-berlin.de>,
"Ulrik Hoffmann" <ulrik_at_hoffmann-kiel.de> wrote:
> Hi Dave,
>
> the following should work
>
> CREATE OR REPLACE TRIGGER TR_YOUR_TABLE_BIU
> BEFORE INSERT OR UPDATE ON YOUR_TABLE
> FOR EACH ROW
> DECLARE
> v_datestr varchar2(20) :=to_char(:new.date,'ddmmyyyy')||:new.time;
> BEGIN
> :new.fulldatetime:=to_date(v_datestr,'ddmmyyyyhh24mi');
> END ;
>
> Hope that helps,
>
> bye
> Uli
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 17 1999 - 20:42:57 CST