Post reply

Enterprise Manager create date wrong format for tables, views etc...

  • October 10, 2006 at 2:46 pm

    #62212

    I've got a new box with sql server 2000 and 2005 databases.

    When i open EM in detail view under tables, views, stored procedures etc...

    i see a create date format of yyyy-mm-dd.

    I can't even sort this column to find out if there was anything created recently.

    How can i change the format to mm-dd-yyyy?

    Thanks

    Alex S

  • October 11, 2006 at 10:01 am

    #665260

    I think this formatting is coming from your operating system. Try changing the date display in Windows regional settings. Regardless, it should still sort properly as it sorts on the underlying data value (a float number).

Viewing 2 posts - 1 through 1 (of 1 total)

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