Date format different from US English - AGAIN!

Question

Date format different from US English - AGAIN!

dig

SSC-Addicted

Points: 435
More actions
March 28, 2003 at 5:45 am

#159707

Dear Hanslindgren, Chrhedga, SQLBill
OK, it's about that same previous topic -- it may sound strange, for me too, but -- since your last post, I did not succeed any more in posting, or replying in that previous-and-similar topic!: the proper space for replying just remains blank, above the postings already made!!! (I emailed webmaster@sqlservercentral.com last 26thMarch but, up to now, didn't get an answer. That's why I'm "overlapping" the problem this way!)
Well, if I was a newbie, I think that, now, I'm not so much any more!!!
Thanks to hanslindgren, and then chrhedga and, following, SQLBill, I learned a lot, and:
1 - following your instructions, I tested the SELECT statement, in Query Analyzer, and You were right: the output, there, was date-and-time in USEnglish way, and...
2 - there it was!, I got it!!!: actually, the problem WAS NOT in SQL - but IN ASP: in the way ASP was displaying the date in the webpages!!!!! - and
3 - I had to get a program to CONVERT it to Brazilian style (dd/mm/yyyy).
I search in WWW, and found in PlanetCodeSource (http://www.planet-source-code.com/vb/scripts) a simple-and-efficient code, from Pritesh Sheth, just called "Date Formatting", with a huge lot of options for any kind of displaying mode You want. Simple -- like any good idea!, like all your advice to me!!!!!
My problem being solved, let me be abused, and post You an-other:
- Why?, in "security" options in my database inside SQL Server, did I have to set the "Brazilian" language...? What does SQL use it for...?
Again, I want to thank very, very much for all your kind attention, efforts ...and, more than all that, for your patience with me!!!
God bless You.
Dalton

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

Dalton, great that the problem is solved!

quote:
- Why?, in "security" options in my database inside SQL Server, did I have to set the "Brazilian" language...? What does SQL use it for...?

I am guessing you mean under Security/Logins and properties for a login account. Is that correct? What you set there is the default language for a specific login, used for example to display date data in a specific format. However, any application can change this setting if they want. See this page for more info: http://msdn.microsoft.com/library/en-us/architec/8_ar_sa_0dbo.asp

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

SQLBill SSC Guru Points: 51440 More actions · Answer 2

SQL Server includes several tools; Enterprise Mangager and Query Analyzer are just two of them. Setting the language in SQL Server doesn't change how the datetime is stored, but it does set how it is displayed in Enterprise Manager and Query Analyzer. Why isn't the datetime showing up as Brazilian format then? Well, for your login you have it set to English. Go to your login, Properties, and change the language to <default>.

-SQLBill

dig SSC-Addicted Points: 435 More actions · Answer 3

chrhedga, SQLBill

Again, You reached the aim of it!

1 - well, I went to the MSN page. Anyway, MSN answered it...: for - my - level of knowledge about SQL, ...OK!

2 - under the security/login expanded option of my Database, I had already set "Brazilian" language as default -- and at "server settings" tab in general "Properties" of my Database, also!: I had already done it...

3 - Thank you, again, very much!

Dalton

Hans Lindgren SSChampion Points: 10496 More actions · Answer 4

I am happy to hear that the problem has been resolved, happy if I were of any assistance

Good luck in the future!

Regards, Hanslindgren