| Subject | Re: [firebird-support] Removing date of 00/00/0000 |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-02-17T06:55:05Z |
At 10:32 PM 16/02/2005 -0800, you wrote:
Firebird doesn't display dates (or anything else!!); so find out what date
value your client environment is interpreting as '00/00/0000' by sampling
the key of a row where it appears, and using isql to find out what that
date represents. (isql will output a date as a valid Firebird date
literal); then use that as your search criterion for the update.
./heLen
>I somehow got some dates in a table that display as 00/00/0000. I want toIt *is* invalid.
>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?
Firebird doesn't display dates (or anything else!!); so find out what date
value your client environment is interpreting as '00/00/0000' by sampling
the key of a row where it appears, and using isql to find out what that
date represents. (isql will output a date as a valid Firebird date
literal); then use that as your search criterion for the update.
./heLen