34,876
社区成员
发帖
与我相关
我的任务
分享如何判断字段为datetime型的值为空？
....where datecol = null ?
....where datecol = 'null'?
....where datecol = ''?
....where datecol = '1900-01-01' ?
为什么都没有用呀？
....where datecol = 'null'?
....where datecol = ''?
....where datecol = '1900-01-01' ?
为什么都没有用呀？
...全文
请发表友善的回复…
发表回复
hphong 2005-01-26
- 打赏
- 举报
....where datecol is null
....where datecol is not null
....where datecol is not null
rtere 2005-01-26
- 打赏
- 举报
判断为空时，datecol is null，如果要判断日期写过值的空，datecol<＝0
cloudchen 2005-01-26
- 打赏
- 举报
datecol is null
Andy__Huang 2005-01-26
- 打赏
- 举报
不為空
....where datecol is not null
....where datecol is not null
cloudchen 2005-01-26
- 打赏
- 举报
datecol is null
Andy__Huang 2005-01-26
- 打赏
- 举报
....where datecol is null
