insert date and ime stamp in table

[dsd7038]

How do I insert the date and time stamp in a table. At present i insert values (sysdate).

How do I get date and time.

Please advise.

[DaPi]

SYSDATE includes date & time. Show both with:
Select to_char(date_stamp_column,'DD-MON-YYYY HH24:MI:SS') From etc etc etc

[slimdave]

sysdate is is date + time.

to see the time portion, either ...

alter session set nls_date_format = 'DD-Mon-YYYY HH24:mi:ss';
select my_date from my_table;

.. or ..

select to_char(my_date,'DD-Mon-YYYY HH24:mi:ss') from my_table;