Hi williams..

I agree with u..

But whats my friend's requirement is to change the settings which attained by sql server 2005..

by default it is coming like

SET DATEFORMAT mdy;

select getdate()

Result:

2008-07-28 10:26:25.920

Can I able to change it in to Date/month/Year format