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

```
Try this:

```
where myColumn < cast( (cast(getdate() - 0.5 as int)) as datetime)

```