title: SQL: how to extract the month from a date time field
body: <p>I need to to extract the month from date time fieldA then put the result into fieldB as an integer in the same table IF fieldB is empty. </p>
  
  <p>eg) <code>1988-02-03 00:00:00.000</code> I need to extract 02 and put the result into another field only if that field is empty.</p>
  
  <p>I guess this will end up as a stored procedure.</p>