Simple query

[Naoise]

If I were to do something like

select datediff(hour,myfieldtime,getdate()) as 'TimeDiff'
where 'TimeDiff' > 24

I would get an error

Syntax error converting the varchar value 'TimeDiff' to a column of data type int.

as it does not see TimeDiff as a field. How would I best express the above?

 

[r937]

select datediff(hour,myfieldtime,getdate()) as TimeDiff
  from daTable
 where datediff(hour,myfieldtime,getdate()) > 24

r937.com | rudy.ca

 

[Naoise]

Cheers, I thought there was going to be some ansi fu way of doing it!

 

[r937]

perhaps an inline view (a.k.a. derived table) will be useful

select TimeDiff
  from (
       select datediff(hour,myfieldtime,getdate()) 
                  as TimeDiff
         from daTable
       ) as d  
 where TimeDiff > 24

r937.com | rudy.ca