如果日期值为空，则转换为返回0

本文介绍了如果日期值为空，则转换为返回0的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好朋友， 我正在尝试关注查询

Hello friends, I was trying following query

select CONVERT(date, MIN(actiondate)) from tbl_action_history

有什么方法可以检查，如果CONVERT(date, MIN(actiondate))为NULL，那么如何获取值0. 在此先感谢

Is there any way to check, if the CONVERT(date, MIN(actiondate)) is NULL then how to get value 0 as a result. Thanks in advance

推荐答案

我不清楚要做什么.. 但您可以通过这种方式找到.. iam not clear what you want to do.. but your can find in that way.. declare @Check varchar(50) declare @Result int select @Check= CONVERT(date, MIN(actiondate)) from tbl_action_history // Your Condition if (@Check=null and @Check='''') begin set @Result=1 select @Result end else begin set @Result=0 select @Result end