>What would be the TSQL syntax that would extract rows where the adddate (a datetime column) was later than 2PM on 11/18/2014?

OK, there are several ways so I'm sure others might reply as well, but here's one way:

I did this for a test row where getdate() returned 11/19 at about 10:20 PM. So my check below is based on 11-19 at 10:00 PM or greater.

CREATE TABLE TestDateTime  ( TestDateTime datetime)

insert into TestDateTime values ( getdate()  )

select * from testdatetime where TestDateTime >= cast('2014-11-19 22:00:00' as datetime)  -- 1 row
select * from testdatetime where TestDateTime < cast('2014-11-19 22:00:00' as datetime)  -- 0 rows