Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Why is displayed date format different in SSMS 2008?

 
   Database Help (Home) -> Programming RSS
Next:  kk  
Author Message
Billy

External


Since: Jan 21, 2009
Posts: 3



(Msg. 1) Posted: Thu Nov 12, 2009 5:39 am
Post subject: Why is displayed date format different in SSMS 2008?
Archived from groups: microsoft>public>sqlserver>programming (more info?)

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

 >> Stay informed about: Why is displayed date format different in SSMS 2008? 
Back to top
Login to vote
Billy

External


Since: Jan 21, 2009
Posts: 3



(Msg. 2) Posted: Thu Nov 12, 2009 6:13 am
Post subject: Re: Why is displayed date format different in SSMS 2008? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Nov 12, 3:01 pm, "Uri Dimant" wrote:
> 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" wrote in message
>
>
>
>
>
> > 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- 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?

 >> Stay informed about: Why is displayed date format different in SSMS 2008? 
Back to top
Login to vote
Uri Dimant

External


Since: Aug 24, 2003
Posts: 1744



(Msg. 3) Posted: Thu Nov 12, 2009 9:25 am
Post subject: Re: Why is displayed date format different in SSMS 2008? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" wrote in message

> 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
 >> Stay informed about: Why is displayed date format different in SSMS 2008? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Date Format - Hi All, Can any one tell me how to format the date time in tsql in this format mm/dd/yyyy hh:mm am/pm (1/22/2009 6:00am) Thanks Balaji -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200804/1

Date format - Hello Everybody, I want to return following date format (without second and millisecond and in AM/PM) 10 Jun 2008 10:00AM I am not able to find any. Please Let me know

Date Format. - Doing this in SQL 2005. SELECT OrderDate FROM MoxyOrders And my OrderDate has a DataType of DateTime. When I run this, I get the date and time. Like 8/5/2008 11:50:20 AM 8/6/2008 2:15:30 PM 8/6/2008 3:30:45 PM etc. When I run this statemen...

Format Date predefined - Hi, is there any predefined format of date like this? 2007-Dec-01 I know that I can do it, but I need to know if there is any predefined. Thank you.

Is a UDT the best way to force the format of a date? - I have a smalldatetime called MyDate in a table. Anytime a user accesses MyDate with a select statement. I would like to have MyDate returned in the format mm/dd/yyyy. I would like the user to not have to explicitly put CONVERT(CHAR(10),MyDate,101) in...
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]