Expression of non-boolean type specified in a context where a condition is expected near 'End Time'

Question

 SELECT  AgentId, StartTime, 
 EventTo =     dateadd(hh,datepart(hh,StartTime)+1,convert(datetime,convert(varchar,StartTime,112 ))),
 EndTime
 from [stage].[Agent]
 where  EndTime is not null and StartTime is not null

The above line will produce an error when I run within a tool called DbFit, however it will run successfully in SSMS.

An expression of non-boolean type specified in a context where a condition is    expected, near 'EndTime'.

The only way to reproduce the error in SSMS is as follows:

      SELECT  AgentId, StartTime, 
 EventTo =     dateadd(hh,datepart(hh,StartTime)+1,convert(datetime,convert(varchar,StartTime,112 ))),
 EndTime
 from [stage].[Agent]
 where  EndTime

Any ideas as to what is the issue and how to resolve it...

I would imagine you have some invalid characters instead of spaces, because the syntax seems valid. Although the spaces are really spaces in the posted query — t-clausen.dk, Nov 09 '15 at 10:26
How are you running the query? Any chance you are selecting upto 'where EndTime` and running, instead of selecting the whole query? That is the only way I can reproduce the error. — shree.pat18, Nov 09 '15 at 10:30
Yes, I did that and I get the error. That is why I initially cut and pasted that query instead instead of the full query — Nobody, Nov 09 '15 at 10:33
If you have a question about incorrect code, you shouldn't edit it later so that it contains correct code. That makes the question make *no* sense. — Damien_The_Unbeliever, Nov 09 '15 at 11:01
I'm going to take a guess here that your tool is truncating the query you've given it. If you run SQL profiler, what is the query that is being run? — Jesse Petronio, Nov 09 '15 at 12:09

score 0 · Answer 1 · answered Nov 09 '15 at 16:53

0

This is a workaround more than a answer. It is existing issue with DbFit. See https://github.com/dbfit/dbfit/issues/284 for more details

answered Nov 09 '15 at 16:53

Nobody

549
1
10
24

Expression of non-boolean type specified in a context where a condition is expected near 'End Time'

1 Answers1