title: Permanently convert datetime to date
body: <p>I have a postgres database with a datetime field. I'd like to permanently convert it to a date field (i.e. remove the time element). What is the best way to go about that? Is there a way to do it in place without having to dump the table into a new table?</p>