Date today question

From: John W. Hamill 265-3624 <johnh_at_gmcid.vssm.gmeds.com>
Date: 1996/09/04
Message-ID: <50kqvo$1ln_at_jupiter.cps.plnin.gmeds.com>#1/1


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!!
Received on Wed Sep 04 1996 - 00:00:00 CEST

Original text of this message