This is why I structure stored procedures with temp tables instead of variables. It's not about performance. It's not about best practices. It's about getting out of the office on time.
All in T-SQL
You don't always get to choose your production software. Anytime a professional software product stores a date as a float it seems like someone should get a good scolding. There are rare occasions where a float is a necessary design decision, but that doesn't make it mean you need to enjoy working with that database.