Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Insert sysdate - Need assistance

Insert sysdate - Need assistance

From: Jimi <Jimi_at_NOSPAM.com>
Date: Tue, 1 May 2001 16:44:43 +1000
Message-ID: <hWsH6.3236$VM5.104865@ozemail.com.au> 






Hi,



I am having trouble inserting the system date into Oracle 8i, can anyone
help me with the syntax?



Sean



strInsert = "INSERT INTO FIX ( RID, DATEREC, NAME, DEPARTMENT, STANDARD,
FIXIT, RNAME, PROBLEM, CURRENTSTATUS) VALUES (" & intTempKey & ",
DATEREC=TO_DATE('SYSDATE', 'DD-MON-YYYY'), '"&UCASE(name)&"',


'"&UCASE(department)&"', '"&UCASE(standard)&"', '"&UCASE(fixit)&"',

'"&UCASE(rname)&"', '"&UCASE(problem)&"', '"&UCASE(currentstatus)&"')"

Received on Tue May 01 2001 - 01:44:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US