insert date and ime stamp in table

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.

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

sysdate is is date + time.

to see the time portion, either ...

Code:

---

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

---

.. or ..

Code:

---

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

---