Re: Date today question

In article <50kqvo$1ln_at_jupiter.cps.plnin.gmeds.com>, "John W. Hamill 265-3624" <johnh_at_gmcid.vssm.gmeds.com> writes
>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 (??????);
>
>I'm looking for a function call like date('today') or to_date('today')
>or something similar to place in the command above where the ????? are.
>
>--
>John W. Hamill, EDS `""""""" PROFS: SMTP(JHAMIL01) Voice:(810)528-6139
>Mail Drop 28 (. (. > lnussat.jhamill_at_eds.com Fax :(810)528-6408
>1450 Stephenson Hwy R1100RS 94BMW There is a $50.00 charge for any junk sent
>Troy, MI 48083 KZ440D2 LTD 81Kaw to me. The above are my views only!!

insert into tablename (date_field) values (sysdate);

-- 
Chris Dipple, Production DBA, Royal Bank of Scotland