Datetime format

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 13, 2006 at 3:41 pm

  #111444

  Hi,

  I have Two servers windows 2003 with the same configuration and SQL 2005 server.

  For each server, I restore SQL database 2000. But on first server I have got a good date format. But in the second, datetime format has change.

  The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.

  I can't to change format in store procedure or format in software.

  How can I change the format on my sql server.

  I want this format : 13/03/2006 23:15:16

  And Now I have : 2006-03-13 23:15:16

  ---

  Kindest Regards,

  degrem_m
  Degremont

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 13, 2006 at 4:57 pm

  #626398

  I found.

  I create a new user SQL and in this properties, I have select French in default language.

  ---

  Kindest Regards,

  degrem_m
  Degremont