Date/Time format has changed on IIS 5
I recently re-installed my webserver (win2k, IIS 5.0) and the date-tmie format has changed from the British dd/mm/yy to the American mm/dd/yy. I have set the regional options to UK time and date format, but this has not helped.
I have read somewhere that IIS uses its own format for date and time. Is this true? How can I change it to the required format?
Date/Time format has changed on IIS 5 (registry fix needed too)
In addition to changing the local under Control Panel|Regional and Language...
I also had to change the Registry settings:
(use regedit from the commandline)
In my case I needed it to change to MM/dd/yyyy
Yours may be different.
THEN finally things like "now()" in classic ASP appear in the format I wished.
This also solves the problem of SQL Date out of range error...and yes I know there are proper ways to put dates into databases which don't lead to these problems...but when you inherit code...and they want you to keep the lights on...well you get the picture.
The regedit change worked for me with IIS on XP.