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 |
|
paulangulo
Starting Member
3 Posts |
 Posted - 2004-07-01 : 09:15:40
|
| I am in the UK - I have a test database where the default language is US english therefore date format being mm/dd/yyyy and all dates are displayed in dd/mm/yyyy through the front end which correct.However on our live system the default language is British English (dd/mm/yyyy) but some screens are displaying dates in this format and others in yyyy/mm/dd format. The software are suppliers are trying to say this a SQL server issue but it can't be can it?I've only checked the sysconfigures table for the above info in the Master db. Is there anything else I should be checking?ThanksPaul. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-07-01 : 09:20:15
|
| Yeah, whoever wrote your software should have formatted all the dates themselves, seem to me like they were being lazy and making assumptions... If you want to get consistent dates from SQL Server, you need to format them in your select... |
 |
|
|
|
|
|
Default language and date format