title: Datetime in SQL Server and C#
body: <p>I have this simple query </p>
  
  <pre><code>insert into my_table(date) values(getdate())
  </code></pre>
  
  <p>The result is <code>2017-01-05 12:41:37.273</code>.</p>
  
  <p>I want when I do</p>
  
  <pre><code>select * 
  from my_table
  </code></pre>
  
  <p>from my Windows Forms application to set the label1.text = 5 Thu 12:41 </p>
  
  <pre><code>2017-01-05 12:41:37.273 ----&gt; 5 Thu 12:41
  </code></pre>
  
  <p>How can I achieve that with C# code ?</p>