Dear Sirs
Because I had to reinstall Windows 2000 Server today, the former (up to yesterday) and original configuration of SQL Server 2000 for DATE format changed!
So, where the tables used to display the dates as (for instance) "23/12/2001", form now they are showing an strange formation as... "23/12/aaaa"...!?!!!???
Please be informed that -- in the "Properties" window of the actual running Server, in the SQL Server Enterprise Manager console, the "General" tab shows the "Language" option as "English (United States)", while the "Server settings" tab shows that the "Default language for user" is the "Brazilian" (i.e., the Brazilian Portuguese). So, I ask You:
1 - WHAT happened? but, more than this:
2 - HOW can I configure the SQL Server 2000 settings to have as DEFAULT date format (as it'a used in Brasil) the "numeric date format" = "dd/mm/yyyy"?
Thanks, many thanks in advance!
Sincerely yours
Dalton H Iberê Gilson
Because I had to reinstall Windows 2000 Server today, the former (up to yesterday) and original configuration of SQL Server 2000 for DATE format changed!
So, where the tables used to display the dates as (for instance) "23/12/2001", form now they are showing an strange formation as... "23/12/aaaa"...!?!!!???
Please be informed that -- in the "Properties" window of the actual running Server, in the SQL Server Enterprise Manager console, the "General" tab shows the "Language" option as "English (United States)", while the "Server settings" tab shows that the "Default language for user" is the "Brazilian" (i.e., the Brazilian Portuguese). So, I ask You:
1 - WHAT happened? but, more than this:
2 - HOW can I configure the SQL Server 2000 settings to have as DEFAULT date format (as it'a used in Brasil) the "numeric date format" = "dd/mm/yyyy"?
Thanks, many thanks in advance!
Sincerely yours
Dalton H Iberê Gilson
