title: Get localized Month Name in Concat function from query MySQL
body: <p>In the db table 'items' I have a column 'date' (type date). In my query I want to build a string from a couple of columns including this date column, but I want the date to be displayed as month name and localized in the string at the same time. So if the date is 1-1-2014 I want to have 'some text in column1 Janvier' or 'some text in column1 January' in mystring depending on locale fr or en etc.</p>
  
  <p>This is what I have in my model:</p>
  
  <pre><code>$select = $this-&gt;select()
  -&gt;from('items', array(items.".*" , 'mystring'=&gt;new Zend_Db_Expr('CONCAT('column1', 
  'month'=&gt; new Zend_Db_Expr('date-&gt;get(Zend_Date::MONTH_NAME)'))  
  -&gt;where('somecondition = true');
  </code></pre>
  
  <p>This gives me an error in the SQL syntax. 
  I know SQL has MONTHNAME but that is not localized and only returns English.</p>
  
  <p>Is it possible to get a localized month name with Zend_Date from a date column within a SQL query? </p>