SQL Date format
Posted on 2003-11-25
Platform: Windows XP Professional + SP1a, Office XP Professional + SP2, SQL Server 2000 + SP3a, Microsoft Excel 2002.
I am experiencing a bit of difficulty with some dates in a query of mine. I'm using the Microsoft Calendar control as a date picker on the client, and it works just fine. I'm in Australia, so the date format is spits out is in the format: dd/mm/yyyy. Unfortunately, the sql server is reading the date as mm/dd/yyyy, which fails for values like 13/01/1979. Thinking it was a difference in regional settings between the client and the server, I checked and found that they are both set to use English(Australia) as both the system and the user input locales.
I would really appreciate some help with this, I'm sure it's going to be a setting I have overlooked.
Thanks in advance...