I need to trim off the timestamp from the date. So, I used the usual technique: floor(date(field)). However, I get nulls returning (i.e., it doesn't trim properly). In fact, when I just use floor(field), I still get nulls. So, something is wrong with the floor function on my field. How do I resolve this?