Hello. I am using Microsoft SQL Server Management Studio (SQL Server 2005). When I select a date column from a table, the date is displayed in "mm/dd/yyyy hh:mm:ss" format. Is there a way i can change this date format so that it shows "dd/mm/yyyy hh:mm:ss" permanently Thanks.

help in sqlserver
jphughes
Lorenzo C
hi
thanx 4 replying
well the date has to displayed in a grid view at client side
one more thing i would like to ask is that i hav found the similar ques being
posted by some other mem can i access the answer to that