| Subject | Removing date of 00/00/0000 |
|---|---|
| Author | Joe Martinez |
| Post date | 2005-02-17T06:32:32Z |
I somehow got some dates in a table that display as 00/00/0000. I want to
set them to null. I tried the following:
update customer set custdate2 = null where custdate2 = '00/00/0000'
This gives me an error that 00/00/0000 is invalid. How can I do this?
-Joe
set them to null. I tried the following:
update customer set custdate2 = null where custdate2 = '00/00/0000'
This gives me an error that 00/00/0000 is invalid. How can I do this?
-Joe