Translate

Wednesday, 6 September 2017

sql : check date as null and blank and select query

select (case when t.STATUS_DATE is null  then '' when t.STATUS_DATE='' then '' when t.STATUS_DATE<>'' then convert(varchar(50),t.STATUS_DATE,103)end) as 'STATUS_DATE' from Mst_Emp

No comments:

Post a Comment