title: Get first date of month in postgres
body: <p>I'm trying to get a 'date' type that corresponds to the first day of the current month.  Basically one of my tables stores a date, but I want it to always be the first of the month, so I'm trying to create a trigger that will get now() and then replace the day with a 1.</p>