insert timestamp

[leonard905]

Hi all,
Can someone please give me an exmple as to how to insert the current date and timestamp into a date field.


Thanks,
Leonard905

[nealh]

insert into table (date_column) values (sysdate)

[tamilselvan]

create table testemp ( empno number , inserted_datetime date default sysdate);