SET DATEFORMAT dmy

• eamonroche

  SSCommitted

  Points: 1678

  More actions

  October 17, 2003 at 10:20 am

  #83332

  If at the beginning of a Stored Procedure I put the line

  SET DATEFORMAT dmy

  does the dateformat change:

  A. Just for that SP?

  or

  B. For the entire database, until such time that I change the DATEFORMAT again?

  Thanks in advance.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 17, 2003 at 6:48 pm

  #478699

  Just for the SP itself.