Subtract two date fields 1

[TitleistDBA]

I have two data fields. They are both datetime datatypes

[Date open] and [Closed on]

I need to select all the records in my table
where [Date Open] - [Closed on] < 4 hours

Does anybody know how to do that?

http://www.acushnetcompany.com

http://www.titleist.com

 

[SQLDenis]

where datediff(hh,[Date Open] , [Closed on]) < 4

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[TitleistDBA]

Once again Denis you come to the rescue!

Thanks for your help.

http://www.acushnetcompany.com

http://www.titleist.com