Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date/Time Trigger Problem

Re: Date/Time Trigger Problem

From: <dcody_at_my-deja.com>
Date: Thu, 18 Nov 1999 02:42:57 GMT
Message-ID: <80vp3i$se5$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US