Trigger HELP

I have a table in which I will want a date and time to be stored when a visitor visits my site and fills the form. I have a trigger that automatically inserts the date, but the time.
http://www.netikka.net/leo
Here is my code

create or replace trigger visitor_date_created
before insert on visitors
for each row
begin
:new.date_created := to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
end;

But this returns an error.

Please give you solution

thanks

Leonard

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].