title: SQL Server - how can I select date-hour from a date-time field
body: <p>How can I do the oracle equivalent of:</p>
  
  <pre><code>to_char(date_field, 'YYYY-MM-DD:HH')  # e.g. 2012-05-25:19
  </code></pre>
  
  <p>in SQL Server ?</p>
  
  <p>I want the column for ordering which is why I want <code>year-month-day-hour</code></p>