Post reply

need where clause with date is blank

  • August 8, 2014 at 3:03 am

    #289687

    trying to get query where date is blank. can anyone help me?

  • August 8, 2014 at 3:06 am

    #1736332

    WHERE <date column> IS NULL

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 8, 2014 at 3:12 am

    #1736333

    zafar.majid (8/8/2014)

    trying to get query where date is blank. can anyone help me?

    Which data type does date have? Because a blank date with an actual date data type does not exist (the empty string gets converted to a default date).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply