I have a similar problem. I have lots of tables where the time part is getting stored and need to quickly ensure only the date is stored without changing app...