Re: Date today question

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);

Ed Mitchell
DBA
EDS
emitch01_at_dsgxhp01.gaxix.slg.eds.com Received on Thu Sep 05 1996 - 00:00:00 CEST