Post reply

Profiler duration question

  • May 25, 2005 at 6:24 am

    #113919

    In running profiler to see activity in the database the duration column puts this in milliseconds. This is a pretty stupid question but how do you convert this to actual seconds ?  Do you multiply by 1000 ? 

  • May 25, 2005 at 7:05 am

    #560935

    I am currently doing the same thing...  DIVIDE milliseconds by 1000 Please note you need to CAST or CONVERT the milliseconds side to DECIMAL or NUMERIC LIKE NUMERIC|DECIMAL (18, 4) or some other variant to give you something or than 0....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • May 25, 2005 at 7:56 am

    #560965

    Or there's always the trick of dividing by a decimal :

    Select 2 / 1000 as [int], 2 / 1000.0 as [decimal]

    int decimal

    ----------- ----------

    0 .002000

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

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