Re: Oracle data/time stamp

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: 2000/05/17
Message-ID: <8fuml5$qt2$11$1@news.t-online.com>#1/1

> 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.
>

SYSDATE returns current date and time! if you want to display the time on the screen you have to convert sysdate using to_char with the relevant parameters
Or you have to change the default setting displaying date fields

Regards
Nicolas Bronke Received on Wed May 17 2000 - 00:00:00 CDT