DateFormats

[Morpheus1981]

When I make a query in the query Analyzer, the dateformat by defualt returned is year/moth/day. I would like change it. I mean is if I do something like :
select GetDate()
The format will be for instance day/month/year.

Thanks.

 

[tlbroadbent]

Check out my "Dates in SQL Server" page.

http://tlbroadbent.home.attbi.com/sql/ss_datetime.htm

If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm