Change date format

HI,

I have noticed that SQL SERVER 2005 uses American date format but i want to change it to UK/European time format i.e. dd-mm-yyyy

can any on tell me how to do it in sql server settings. And is it possible that I can change it only the during the course of my STORED PROCEDURE.

I know it is quite and any one will answer that soon

hoping quick reply

regards,

Anas

DanHockley

thanx for ur reply...

other query is that how will I able to change that setting for the course of my stored procedure is it possible

waiting for your reply

regards,

Anas
nibsi
That shouldn't be necessary once the database has been set to the correct language. But IIRC, you can set the language on a connection basis, but you should be able to locate this info in the SQLServer help file, I can't recall what the setting might be at the moment, probably SET LANGUAGE <language>
Karl Seguin - MVP
I haven't used 2005 yet but assuming it has the same 'problem', make sure the language is set to 'british english' instead of 'english'
Change date format