Post reply

Enterprise Manager - DateCreated display format

  • April 5, 2006 at 5:25 am

    #152888

    Hello, I colleague has a problem with the date format which is displayed in the tables view from Enterprise Manager.

    The datecreated field shows in the format 2006-10-03 for all tables.  For all other databases it is showing how we would expect (dd/mm/yyyy).  The views all show in the expected format as well.  All other people who have this server registered see the tables view in dd/mm/yyyy format.

    Strange one I know.  I can only think it must be something local to his machine unless there is some view/format settings somewhere I don't know about?

    Any suggestions would be appreciated.

  • April 5, 2006 at 8:10 am

    #631006

    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 !!!**

  • April 5, 2006 at 11:57 am

    #631074

    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.

  • April 5, 2006 at 1:53 pm

    #631091

    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 !!!**

  • April 5, 2006 at 2:20 pm

    #631093

    Yes, Miss Smarty-Pants !  I am weaning myself away from EM 

  • April 5, 2006 at 2:22 pm

    #631095

    Yes, Miss Smarty-Pants !  I am weaning myself away from EM 

  • April 7, 2006 at 8:50 am

    #631525

    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

  • April 7, 2006 at 11:28 am

    #631561

    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. 

     

     

  • April 7, 2006 at 12:18 pm

    #631575

    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 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply