Date Format Issue

Hello,

I have a web application that makes a simple Select query to a SQL 2000 database. This application is hosted on a load balanced farm, where each web server is supposed to be configured identically -- same code base, same iis configuration, same connection strings, etc.

My problem: When I execute the query on one of the servers in the farm, the date that gets returned includes a leading zero in the month, e.g.'08/26/2005'. The rest of the servers, executing the same query from the same database, does not include the leading zero, e.g.'8/26/2005'

What about the one server is different? Any insights would be much appreciated!

Check system settings for long and short date format.

Thanks

|||

Thanks for the quick turnaround! My dumb followup questions are:

Where do I review this information? I think I can find it in the registry under HKCU\Control Panel\International, but is that the best place to make a change, or is there a Windows-provided interface?

|||

Regional and language option in control panel

Thanks