Re: Insert sysdate - Need assistance

  Emil,

I can't get the syntax correct this is my statement

strInsert = "INSERT INTO FIX ( RID, DATEREC, NAME, DEPARTMENT, STANDARD, FIXIT, RNAME, PROBLEM, CURRENTSTATUS) VALUES (" & intTempKey & ",

'"&(SYSDATE)&"', '"&UCASE(name)&"', '"&UCASE(department)&"',
'"&UCASE(standard)&"', '"&UCASE(fixit)&"', '"&UCASE(rname)&"',
'"&UCASE(problem)&"', '"&UCASE(currentstatus)&"')"

And this is the output, i have tried many ways of using sysdate in my insert querys but i either get an error or i get no value returned.

INSERT INTO FIX ( RID, DATEREC, NAME, DEPARTMENT, STANDARD, FIXIT, RNAME, PROBLEM, CURRENTSTATUS) VALUES (285, '', 'NATHAN WARD', 'ENGINEERING', 'AS/NZS ISO 9001', 'CORRECTIVE ACTION', 'ENG - ACTIVATION AND TESTING', 'TEST ', 'OPEN') Any ideas about syntax?

Thanks in advance

Emil Andrici wrote in message <3aeea951$1_3_at_news01.one.net.au>...
>What's the point of converting a date (SYSDATE) to date again?
>Replace DATEREC=TO_DATE('SYSDATE', 'DD-MON-YYYY')
>with SYSDATE or TRUNC(SYSDATE) if you want to ignore the time.
>
>Emil
>
>
>Jimi wrote in message ...
>>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 - 23:40:35 CDT