tb_user_log to collect user login and logout history and it has two cols (
timeout) but if the system error the timeout col is null value.
I need to select it and display even is
null or not
I have below code but just returns only where value is not null and it hide the recode where timeout is null:
where cast(Logintime as date) >= '2018-05-16'
and (cast(Logouttime as date) <= '2018-05-16' or
cast(logouttime as date) <= '')
order by id desc
Is any incorrect point in my code? It does not return the null recode.
Or any better way to select it? My datatype is
datetime and I am using C# + SQL Server 2012.