Re: Help - Setting a date field to NULL

Hello Jason,

Just Try

EXEC SQL update xx

                       set xx_date = ''
                       where ....

('' means two quotas, not a double quota)

Stefan Scheck

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.
Received on Wed May 21 1997 - 00:00:00 CDT