title: How to insert just year and month into date field?
body: <p>I have a column called <code>table_date</code> which currently I am using <code>now()</code> to insert the current date (<code>2011-02-23</code>). I know I can manipulate this with sql/php to show me year and monthname. However, I want to know if it's possible to just insert into <code>table_date</code> the current date as year-month like this <code>2011-02</code>? Thanks</p>