title: Best way to format date in a SQL Server stored procedure
body: <p>This is my example data using SQL Server with <code>date</code> type</p>
  
  <pre><code>TglUnggah = 30/03/2014
  </code></pre>
  
  <p>I need date format 'dd/MM/yyyy'</p>
  
  <p>My stored procedure</p>
  
  <pre><code>ALTER proc [dbo].[SP_ViewFile] 
  AS 
  BEGIN   
     SELECT        
        IdFile, IdAkses, NamaFile, Count, 
        CONVERT(VARCHAR(10), TglUnggah, 103) AS TglUnggah, 
        Keterangan, Role, Url     
     FROM            
        tbFile 
  END
  </code></pre>
  
  <p>When running this stored procedure in ASP.NET, the data is <code>30/03/2014</code>, but in detailview the format changes to <code>30/03/2014 0:00:00</code> and can't been updated</p>
  
  <p>What is the best way to use format <code>dd/MM/yyyy</code> in SQL Server / stored procedure / ASP.NET?</p>