Hands up who finds SQL Server's help the most useless help in the whole
*y history of helps?
I have installed SQL Server 6.5 and created databases that are being used.
I specified English - New Zealand ( Because that's where I am ) when I
installed, but as one would not expect, SS hasdecided to use English -
United States as the date format. This makes things very difficult, because
the web server IIS4 is quite happy to use English - New Zealand format dates
and the SQL server has a major grump about the difference.
Just in case you didn't allready know in NZ we like our dates to go
d/mm/yyyy instead of the US mm/dd/yy.
So how do I change the way SQL server deals with dates?
Hysterically, by some fluke of nature I have only tested the server on dates
which are still sensical when interpreted as US ie. 12/12/98 etc.
A solution other than reinstalling would be very warmly accepted.