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

```
Here is how to get 0 hour of today in SQL

```
SELECT (CAST(FLOOR(CAST(GETDATE() as FLOAT)) AS DateTime))

```

Just compare your time against that.

Don't use varchar casts since they are slow.

[Check this list](https://stackoverflow.com/questions/202243/custom-datetime-formatting-in-sql-server#202288) for more date time help.