Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
glennjh66
Starting Member
1 Post |
 Posted - 2005-10-06 : 00:16:34
|
Hi there,We are testing a new version of a software program developed in the US. To cut a long story short, the application has had mods made to it to allow for international release mostly around date formats. In Australia we use the regional settings English(Australia) with the dates in reverse to those of the US (dd/MM/yyyy).Part of the process for setting up the MSDE is to change the language of the server to British English as well as the sa login used for the application to British English. We are still receiving errors when trying to run some Crystal Reports based on date ranges. One of the things I have noticed is that when I am viewing the properties of the SQL server via Enterprise Manager the language states English (United States) even if all the set to English (Australia) My question is, does anyone know where the SQL is picking up that setting from? The second question is, does that setting have anything to do with the date settings that SQL may utilise or is it just a static reference? I have tried uninstalling the SQL Server and reinstalling, just in case it picks up the regional setting upon installation, but it remains the same.I am curious to know if that could be causing us our date format problems with this application. Thanks in advanceGlenn |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-06 : 04:18:00
|
| Can you format your dates, in queries, in "yyyymmdd" format, or "yyyy-mm-ddThh:mm:ss"?SQL should treat that as being unambiguousKristen |
 |
|
|
|
|
|
MSDE Localisation issues ... maybe