I need to insert a null or '开发者_如何学JAVA00/00/00' date value.
Is it possible to do it on interbase?
I already tried to insert '00/00/00' and it wasn't possible.
According to the literature (I have zero experience with InterBase) you can use standard SQL see section 6-56 "NULLing columns with UPDATE"
UPDATE TABLENAME
SET DATEVALUE = NULL
WHERE SOME_ID = 123
you might have more options depending on your client
精彩评论