| Author |
 Topic  |
|
|
sogoth
New Member
United Kingdom
73 Posts |
 Posted - 07 November 2001 : 05:32:26
|
I know this has been asked by someone else (but before the server move), but I can't seem to find the thread with it on now, so my apologies..
I'm using <% date %> to fill in a form field with today's date, which it does correctly (dd/mm/yyyy), but as soon as it submits it to my SQL server it is flipped around into US format (mm/dd/yyyy).
Both the web server and the SQL server are set to UK date/region so I can't work out where the problem is occuring
help!!
Paul -
*bugger* said the fairy as it flew into a window |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 07 November 2001 : 07:23:59
|
There is a discussion on this Topic, but that is related to these Forums. Since You have posted in Non Forum Related Section, I don't think that will help. However the link to the discussion is here
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=14329
If there was some other discussion, I am not aware of that.
GauravBhabu
There is only one miracle...That is LIFE! | It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
 |
|
|
sogoth
New Member
United Kingdom
73 Posts |
Posted - 07 November 2001 : 09:51:18
|
It was in the SQL Server help area about a month ago but I can't find it now.
I'm trawling through the thread you posted a link to, hopefully it'll come up with something useful...
ta
Paul -
*bugger* said the fairy as it flew into a window |
|
|
|
sogoth
New Member
United Kingdom
73 Posts |
Posted - 07 November 2001 : 10:10:04
|
I've just done some experimenting on the SQL server.
if I place a small file to output Now() on the IIs machine it comes out with the uk date format. If I run the same file on the SQL server it comes out in US date format, even though the actual server settings are for uk timezone and formats.
Where is the date format set on a server? I've checked Date/Time and Regional settings in control panel. Neither are incorrect... where else could it pick up the formatting from?
Paul -
*bugger* said the fairy as it flew into a window |
|
|
|
sogoth
New Member
United Kingdom
73 Posts |
Posted - 08 November 2001 : 05:06:14
|
Simple answer for today is to install a SQL server onto the IIS machine and transfer the databases across.
Paul -
*bugger* said the fairy as it flew into a window |
|
|
| |
Topic |
|
Topic Locked
