Enterprise Manager - DateCreated display format
-
Graham..EM picks up from the regional settings - if you change the date format on his pc you'll see that EM displays the changes too...
**ASCII stupid question, get a stupid ANSI !!!** -
It can also be random. I've encountered that one day (2006-10-03), and the next day they're back to "normal" (3/10/2006). Pretty annoying when you're trying to sort by data. Never did figure out the cause.
-
Hi homebrew01...have never encountered this myself..but have an easy solution for you...don't use EM!!
**ASCII stupid question, get a stupid ANSI !!!** -
Yes, Miss Smarty-Pants ! I am weaning myself away from EM
-
Yes, Miss Smarty-Pants ! I am weaning myself away from EM
-
Have you checked the default language for the user's login? I've seen situations where some logins have English and others have British English, and this can cause differences in the way data is presented.
John
-
We have the same random problem just in a different scenario, it will show as mm/dd/yyyy then one day a new object is created and it shows as yyyy-dd-mm. But as soon as sql server's service is restarted it goes back to mm/dd/yyyy.
sushila is right EM does pickup the regional settings on the local machine. It has to be a bug. It wouldn't be the first time.
-
I have had this happen at least twice to me but mostly after installing updates (OS) or applications and just needed to reboot to clear things up.
Viewing 8 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply