Oracle data/time stamp

I need to insert the current date/time stamp into a field evertime my pl/sql program inserts a row.

I grab the current date like this:

SELECT sysdate
INTO c_date
FROM dual;

but where can I get the current time... it HAS to be available to me somewhere... doesn't it? Ideally, I would want the current date and time together.

Pete

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 17 2000 - 00:00:00 CDT