date format

• Hadrian

  Hall of Fame

  Points: 3742

  More actions

  June 29, 2010 at 3:18 am

  #387238

  Hello,

  I have tables with DATE datatype columns which are in format yyyy-dd-mm.

  My question is how could used this as 'dd/mm/yyyy' without convert into varchar?

  MSSQL 2008 SP1.

  Best Regards,

  Hadrian

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  June 29, 2010 at 3:24 am

  #1186255

  Date data is NOT stored in a particular format.

  Please see this link http://www.karaszi.com/SQLServer/info_datetime.asp

  ---

  
  Clear Sky SQL
  My Blog[/url]