When you cast the date column are you using the built in function system.db.dateFormat(date_cell,“yyyy-MM-dd HH:mm:ss”) ? Or are you casting with your SQL call?
I haven’t had any problems using dates that have “no actual time” like your ‘01/04/2012 00:00:00’.