Question: How do I check if the timestamp date of a record is before midnight today?

datediff is driving me nuts...

Answer: 
Try:

```
WHERE dtColumn < DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

```
Do you mean that the datatype of the column you ate using is "TimeStamp", not dateTime or smalldatetime ?

If so, then you're out of luck. This datatype has nothing to do with dates or times (it's really misleading...) It's just guaranteed to be chronologically unique and sequential... But there's no way ot compare it with a datetime 

<http://msdn.microsoft.com/en-us/library/aa260631(SQL.80).aspx>

<http://www.sqlteam.com/article/timestamps-vs-datetime-data-types>