<p>How do I check if the timestamp date of a record is before midnight today?</p>

<p>datediff is driving me nuts...</p>

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