>>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)
>select * from testdatetime where TestDateTime < cast('2014-11-19 22:00:00' as datetime)
>
Thanks, Kevin
That did it.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.