Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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
![]() |
![]() |