Skip to Content
avatar image
Former Member

IS NOT NULL not functioning as expected


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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 19, 2012 at 06:29 AM

    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.


    Add comment
    10|10000 characters needed characters exceeded

    • 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


  • Oct 22, 2012 at 08:58 PM

    If you just want to see if the value is null, you don't need to apply the to_date() conversion beforehand. Just do WHERE "COLUMN" IS NOT NULL.

    Add comment
    10|10000 characters needed characters exceeded

    • Two mistakes here:

      1. don't digg out two year old threads, that nobody is interested in anymore. Just don't.

      2. the unequal condition you posted tests for an empty string, not for NULL and that's two separate things in SAP HANA.

      - Lars