Right now, we don't allow date values to be cast to integers in the QueryBuilder. It looks like this cast ignores the actual time unit used for the date, but we expect it to produce an integer value according to its time unit (BTW timestamp behavior is different and matches expectations).