title: Date format returned as mm/dd/yyyy hh:mm:ss AM/PM
body: <p>I am brand new to sql my company just kinda threw me head long into this and said do it. So any help is greatly appreciated. I am trying to get a date to come out in the format of mm/dd/yyyy hh:mm:ss AM/PM so for example a date of 09/26/2014 11:04:54 AM. I have tried using the code:</p>
  
  <pre><code>Select Convert(nvarchar,EntryDate,101)
  From DB1
  </code></pre>
  
  <p>However that returns just 09/26/2014.
  I also tried</p>
  
  <pre><code>Select Convert(nvarchar,EntryDate,100)
  From DB1
  </code></pre>
  
  <p>but this returns Sep 26 2014 11:04AM</p>
  
  <p>Not sure where to go from here. Again thanks for the help. BTW I am using SQL Server 2012.</p>