create or replace trigger XYZ
after insert or update on TEST1
begin
update DATE2
  SET DFIELD =sysdate;
end XYZ;

create or replace trigger XYZ
after insert on TEST1
REFERENCING NEW AS newRow
for each row
begin
update DATE2
  SET DFIELD =:newRow.sysdate;
end XYZ;

SQL> desc TEST1
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME NOT NULL VARCHAR2(20)
USERID NOT NULL VARCHAR2(20)
DATEFIELD DATE

SQL> desc DATE2
Name Null? Type
----------------------------------------- -------- ----------------------------
DFIELD NOT NULL DATE
USERID VARCHAR2(20)

SQL>

SQL> create or replace trigger trg_mv_dept
  2        after insert or update on LDAPTEST
  3        for each row
  4      begin
  5  update INSERTLDAPDATE
  6   SET DATEFIELD =sysdate
  7  WHERE USERID = :NEW.USERID;
  8  END;
  9  /

Trigger created.

INSERT INTO "SCOTT"."TEST1" ("USERNAME" ,"USERID" ,"DATEFIELD"
    ) 
    VALUES 
('nick' ,'13' ,TO_DATE('', 'dd-Mon-yyyy HH:MI:SS AM') 
    );
commit;

create or replace trigger XYZ
before insert or update on TEST
for each row
begin
  :NEW.DFIELD := sysdate;
end ;

SQL> create or replace trigger XYZ
  2  after insert or update on TEST
  3  for each row
  4  begin
  5    :NEW.DFIELD := sysdate;
  6  end;
  7  /
create or replace trigger test
                          *
ERROR at line 1:
ORA-04084: cannot change NEW values for this trigger type

create or replace trigger XYZ
after insert or update on TEST1
begin
update DATE2
  SET DFIELD =sysdate;
end XYZ;

SQL> select sysdate from dual;

SYSDATE
---------
16-OCT-08

 
SQL> select TO_CHAR(sysdate,'DD-Mon-YYYY HH24:MI:SS') FROM dual;

TO_CHAR(SYSDATE,'DD-
--------------------
16-Oct-2008 15:58:53

SQL> select sysdate from dual;

SYSDATE
---------
16-OCT-08

SQL> alter session set nls_date_format= 'DD-MON-YY HH24:MI:SS'
  2  ;

Session altered.

SQL> select sysdate from dual;

SYSDATE
------------------
16-OCT-08 10:45:50