Hi !
Try to remove the quotes around sysdate;
DATEREC=TO_DATE( SYSDATE , 'DD....
Frank
Jimi <Jimi_at_NOSPAM.com> wrote in message
news:hWsH6.3236$VM5.104865_at_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 - 02:48:40 CDT
