Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Why is displayed date format different in SSMS 2008?

1 view
Skip to first unread message

Billy

unread,
Nov 12, 2009, 8:39:57 AM11/12/09
to
Hello!

Can anybody tell me where I can set in SQL Server Management Studio
2008 that I will see date columns formatted in style "dd.mm.yyyy" like
it is in SSMS 2005 or in SQL 2000?

With that I mean if I open any table in any db with datetime columns
inside with command "Edit Top 200 rows" or "Select Top 1000 Rows" I
see date in form e.g "2009-10-25 14:40:00.000" instead of "25.10.2009
14:40.000". If I open same table in SSMS 2005 I see in "dd.mm.yyyy"
format.

Regards,
Biilly

Uri Dimant

unread,
Nov 12, 2009, 9:01:46 AM11/12/09
to
Billy
Do not open SSMS , instead of run SELECT statement in query builder and use
CONVERT system function that has a third parameter named style
See details in the BOL

"Billy" <abi...@yahoo.com> wrote in message
news:5dd8d80c-555a-4166...@u7g2000yqm.googlegroups.com...

Billy

unread,
Nov 12, 2009, 9:13:39 AM11/12/09
to
> > Biilly- Hide quoted text -
>
> - Show quoted text -

Problem is that I want to see dates in SSMS 2008 in that format when I
watch raw data. Why this work in 2008 different then in SSMS 2005
where I can see normal like I see everywere else for my local
settings?

0 new messages