Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle data/time stamp
You're alreading doing that, any date column stores time also, so the
sysdate function returns to time too.
Use select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') from dual
to verify.
Hth,
Sybrand Bakker, Oracle DBA
<pete_karanikas_at_hotmail.com> schreef in berichtnieuws
8fuejg$bua$1_at_nnrp1.deja.com...
> 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