IS NOT NULL not functioning as expected

[Former Member]

Hello,

When trying to apply 'IS NOT NULL' operator as filter(where to_date(column) Is Not Null) on the DB column  it is not working as expected and pulling the null values into the result.

We are using HANA Revision 33.Below is the SQL generated from BO tool we are using BO 4.0.

Let me know if you have ever faced this issue.

thanks!

[Former Member]

Hi Ravi,

I tried the same filter in SQL editor its working fine and also not pulling the null values. I am on HANA DB Revision 28.

Can you mention datatype and values of the column you are using in to_date function.

-Ruchi

[Former Member]

Hello Ruchi-

Thanks for your response.

The data type of the field we are using in the condition is DATA TIME STAMP field, we are getting rid of time stamp using the to_date function. to display in YYYY-MM-DD

Thanks!