Difference between SELECT and PRINT statements

• erajendar

  SSC Eights!

  Points: 840

  More actions

  June 27, 2008 at 12:13 am

  #189859

  I ran the below two simple SQL queries in management studio

  SELECT getdate() -- returned 2008-06-26 23:11:44.030

  PRINT getdate() --returned Jun 26 2008 11:12PM

  now I wanted to know why there is a difference in the format returned by SELECT and PRINT statements

  thanks

  
  erajendar

• j nuñez

  SSCrazy

  Points: 2175

  More actions

  June 27, 2008 at 12:48 am

  #835177

  PRINT always returns a char/varchar, so when you make "PRINT GETDATE()" an implicit conversion is made.

  SELECT returns the datatype supplied.