title: Sql Date in Format MMMYY
body: <p>How to  get current date in sql to <strong>MMMYY</strong> i.e. OCT13</p>
  
  <pre><code>select Convert(varchar(10),getdate(),6) this will generate 11 Oct 13
  </code></pre>
  
  <p>I need to get OCT13 .</p>
  
  <p>Any help appreciated.</p>
  
  <p>Front end application cannot do this formating. I am exporting the data from sql to another sql server
  Thanks</p>