September 8, 2002 at 5:32 pm
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
September 9, 2002 at 3:44 am
Ok, first the General tab is the installed version of SQL (english language version in this case). The language for users when created is based on the Server settings default language. However, users can be setup with different languages than that. Try running drilling thru security to the Logins and view the users language, if not matching with Brazilian then open the users login account and change the Laguage at the bottom of the dialog to Brazilian and see if this corrects. Also, I am confused by the /aaaa part, what does it show exactly?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 10, 2002 at 7:40 am
Antares
- Thanks for your first tips
- I made the "updates" You recommended, in "Logins" users, and changed them to "Brazilian" language -- but IT IS STILL KEEPING THE SAME ERROR: instead of displaying (for instance) "23/12/2001", it shows the same and strange formation "23/12/aaaa";
- please be informed that, in that "Logins" section, I put the "default database" for each Login user as "contratosonlinedb", that is the name of my database, under which I'm building all the tables;
- also, answering your question: the expression "/aaaa" stands for "ano" (in Brazilian language), that's to say, "year", in the 4-digit format, which is the most commonly used, now, in Brazil -- the format is "dd/mm/yyyy".
I'd appreciate very much if You, and our Forum-mates, could help me to jump this obstruction!
Thanks in advance!
Dalton
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply