Re: Insert sysdate - Need assistance

From: Emil Andrici <emil_at_one.net.au>
Date: Tue, 1 May 2001 22:01:49 +1000
Message-ID: <3aeea951$1_3@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 - 07:01:49 CDT