开发者

insert null date interbase

开发者 https://www.devze.com 2023-02-02 12:10 出处:网络
I need to insert a null or \'开发者_如何学JAVA00/00/00\' date value. Is it possible to do it on interbase?

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

0

精彩评论

暂无评论...
验证码 换一张
取 消