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

datediff is driving me nuts...

Answer: 
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.
Try this:

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

```