help in sqlserver

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.


Answer this question

help in sqlserver

  • jphughes

    That's a client application is responsible for showing the date. So the question is where do you want to see dates in this format
  • 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



  • help in sqlserver