Posted by Techie123 on 06/29/06 20:17

OKAY, Here's the real story...
I tried the $variable=NULL, not $variable='NULL' and it worked, kind
of. Now I have 1/1/1900 in Enterprise Manager. When I print that out it
comes to 1900-01-01 00:00:00.

So, what's the answer here. That I do not know. I could just change all
my logic to look for that time stamp, but it seems stupid that I can
enter a NULL in manually, but there isn't some SQL command for it.

Techie123 wrote:
> Perhaps I spoke too soon. I need to figure out what to do if I want to
> have a function to erase a date previously entered.
>
>
> Techie123 wrote:
> > IT'S SO EASY I FEEL DUMB. Just completely omit INSERTing a NULL into it
> > all together and it automatically inserts one for you!!!!! This is a
> > really good group! I got my answer and I didn't even have to have a
> > reply! ;-)
> >
> > P.S. - I tried the NULL instead of 'NULL' and it did the same thing.
> > Leaving it out worked for me.

[Back to original message]