>>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
>

Thanks, Kevin
That did it.