See milliseconds when the table is open in SQL Server Management Studio

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  August 27, 2008 at 8:57 am

  #211661

  Hello guys,

  I have the following issue:

  I have some columns with datetime datatype, if the table is open, i seen data in the format without hh:mm:ss.

  If I make a query, I get: hh:mm:ss:Ms

  How can I see the millisecons when the table is open in SQL Server Management Studio.

  Thank

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  August 29, 2008 at 3:31 am

  #864895

  Hello,

  any help will be very appreciated.

  Thank