SQL 2005 - Default Date Formats - Need Help

• chriscrowe

  Grasshopper

  Points: 18

  More actions

  September 16, 2007 at 4:41 pm

  #177478

  Hi

  I have a SQL 2005 server that is in New Zelaand - the New Zealand date format is DMY.

  Currently if I execute print GetDate() I get  Sep 17 2007 10:34AM

  and trying the following

  print cast('2007-09-16' as datetime)

  results in

  Msg 242, Level 16, State 3, Line 1

  The Conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

  I need to setup the defaults to handle the cast above, but I do not know where to start.

  Chris

   

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  September 16, 2007 at 4:49 pm

  #733985

  Try the first link for correct SQL Server DateTime setup and the second link for all the SQL Server DateTime covert codes.  Hope this helps.

  http://www.karaszi.com/SQLServer/info_datetime.asp

  http://sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

  Kind regards,
  Gift Peddie