Re: Help - Setting a date field to NULL

Have you tried
update ... set datefield = '' where ...

Jason Trieu wrote:
>
> Has anyone done setting a date field to NULL? I'm writing embeded
> Oracle SQL trying to set a date field to NULL without any success.
>
> when I have:
>
> EXEC SQL update XX
> set XX_DATE = NULL
> where ...
>
> The pre-compiler complains of mismatch types. However, when I enter
> the statement manually under sqlplus, it workes fine.
>
> If I try:
>
> EXEC SQL update XX
> set XX_DATE = to_date(NULL,'YYYY/MM/DD HH24:MI:SS')
> where ...
>
> I get a run-time error of "Input value too short for date format".
>
> Any help is appreciated.
>
> Jason T.
 

-- 
--------------------------------------------------------------
                  DataWeb Consulting Services
              "Web-enabling your databases today"
voice:(303) 517-3863                       FAX: (303) 422-5107
                       gkainz_at_rmi.net
--------------------------------------------------------------