Hello,
We have a webserver(win2k) that points to a database.
There is an application on the website that records todays date and saves it into the database whenever a user performs a certain function.
Problem is, the date going into the database is American format and we want it to be in English format. Our SQL db is using British English.... So we think the problem lies with the webserver.
To further prove this theory we connected up our test webserver with the live database and performed the same function. The dates were recorded in English format.
The two webservers have identical regional settings for the local admin, domain admin and for the account that accesses the function on the webserver.
Does anybody have anything else to suggest. We are running out of ideas.
Thanks
George
We have a webserver(win2k) that points to a database.
There is an application on the website that records todays date and saves it into the database whenever a user performs a certain function.
Problem is, the date going into the database is American format and we want it to be in English format. Our SQL db is using British English.... So we think the problem lies with the webserver.
To further prove this theory we connected up our test webserver with the live database and performed the same function. The dates were recorded in English format.
The two webservers have identical regional settings for the local admin, domain admin and for the account that accesses the function on the webserver.
Does anybody have anything else to suggest. We are running out of ideas.
Thanks
George
