Re: Insert sysdate - Need assistance

"Jimi" <Jimi_at_NOSPAM.com> wrote in message news:UbMH6.3935$VM5.127397_at_ozemail.com.au...
> 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)&"')"
> >>
> >>
> >
> >
>
>

Why don't you just
alter table fix modify (daterec default sysdate)

in your last statement, the empty string in true Oracle syntax should be NULL. You are still mixing Oracle syntax and VB syntax. Why?

Regards,

Sybrand Bakker, Oracle DBA Received on Tue May 01 2001 - 23:56:28 CDT