>>>Its a DAX funtion http://msdn.microsoft.com/en-us/library/ee634800.aspx
>>
>>So, this is not part of the native SQL Server support?
>
>Sorry to jump in, but HOUR is not a valid SQL function.
>
>The DatePart function that Nicholas mentioned is how you can extract any single part (anything from hour to minute to day, etc) of a date.

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