No date/time in Select statement, getting: Conversion failed when converting character string to smalldatetime data type

Asked May 11 '22 at 19:43

Active May 11 '22 at 20:24

Viewed 37 times

I have the following select statement

 SELECT Distinct lastname, firstname, UserName, r.name as 'Role', ug.name AS 'UserGroup'

and the following where statement

where userid = 894 and (EndDate > '2022-05-11 00:00:00' or endDate = 'NULL')

Getting the following error:

Conversion failed when converting character string to smalldatetime data type.

How do I fix this without entering a date/time in the Select statement?

edited May 11 '22 at 20:24

Dale K

asked May 11 '22 at 19:43

MDL

3

Use am unambiguous format for your datetime literal; either `yyyyMMdd` or `yyyy-MM-ddThh:mm:ss(.nnnnnnn)`. – Thom A May 11 '22 at 19:46
4

`endDate = 'NULL'`? That isn't going to work. You want `IS NULL`. – Thom A May 11 '22 at 19:48
2

What is the data type of `EndDate`? Why would it ever be equal to the _string_ `'NULL'`? Did you mean `or endDate IS NULL`? – Aaron Bertrand May 11 '22 at 19:48

0 Answers0