View Single Post
  #4 (permalink)  
Old March 22nd, 2006, 05:02 PM
jbenson001 jbenson001 is offline
Friend of Wrox
Points: 4,332, Level: 27
Points: 4,332, Level: 27 Points: 4,332, Level: 27 Points: 4,332, Level: 27
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2003
Location: , NJ, USA.
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Sql server determines the date format based on the collation selected when the server was set up. In your case it sees dates as mm/dd/yyyy. Before you run a query you will need to use SET DATEFORMAT. Look it up in books on line