can not compare a datetime variable in sql-server to null value

Question

I want to convert a datetime variable in SQL-Server to string and compare it with an empty string:

CONVERT(varchar(20), @DATEDEB, 1) =''

This is the test I have in my code:

IF (@N_CATComp = 4) AND (@EXON='' OR CONVERT(varchar(20), @DATEDEB, 1) ='' OR CONVERT(varchar(20), @DATEFIN, 1) = '')

the test works even if datedeb and datefin empty

Rahul Tripathi · Accepted Answer · 2016-03-10 13:16:09Z

2

If you want to compare the dates to NULL then you can simply try to use the IS [NOT] NULL

Determines whether a specified expression is NULL.

Something like

@myDate IS NULL AND @myDate1 IS NOT NULL

By using this you don't have to convert your datetime to a string variable.

answered Mar 10, 2016 at 13:16

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hollyx · Accepted Answer · 2016-03-10 13:18:28Z

0

OKay , the answer is in sql-server, @DATEDEB<>'01/01/1900' which is the defult date that sqlç-serveur takes

answered Mar 10, 2016 at 13:18

hollyx

991 silver badge10 bronze badges