Re: Insert sysdate - Need assistance

Sybrand,

I am using Oracle 8i on Windows NT ( Which i have no choice ) and all i want to do is insert the current date into that field, i am still only a beginner any help with this would be appreciated! The site i am working on uses asp pages to interface with the database.

Sean

Sybrand Bakker wrote in message ...
>
>"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 Wed May 02 2001 - 00:12:23 CDT