Re: Date today question

Ed Mitchell wrote:
>
> John W. Hamill 265-3624 wrote:
> >
> > Does anyone know how I can get the system date and insert it into a date filed
> > I'm using a bourne shell and calling sqlplus. the insert statement looks like
> > this
> >
> > insert into tablename (date_field) values (??????);
>
> SYSDATE will give you what you're looking for. It obtains the current
> date. So, the insert statement will look like this:
> insert into tablename (date_field) values (sysdate);

*Wrong*!

SYSDATE is the current date *and* time. TRUNC(SYSDATE) is the current date. Received on Fri Sep 06 1996 - 00:00:00 CEST