title: Datetime2 format to dd/mm/yyyy
body: <p>I have a column in a SQL Server 2008 datatabase that is of the Data Type datetime2. This means my dates are displayed in the format YYYY-MM-DDThh:mm:ss. However, I need my dates to be in the format dd/mm/YYYY by default and I cannot change the column datatype. Also, the datetime2 format is not affected by the SET LANGUAGE and SET DATEFORMAT session locale settings. Finally, I do not want to use the convert() functionality as otherwise I need to rewrite all of my queries.</p>
  
  <p>How can this still be achieved?</p>
  
  <p>Many thanks!</p>