Show millisecond value

Question

Post reply

Show millisecond value

yujinagata72

Ten Centuries

Points: 1072
More actions
August 2, 2016 at 7:18 am

#310206

Hi,
I have the below SQL statement
select
CONVERT(TIME, DATEADD(SECOND, DATEDIFF(SECOND, last_request_start_time, GETDATE()), 0), 114) AS Duration,
* from sys.dm_exec_sessions
where (status <> 'sleeping' or open_transaction_count > 0)
order by last_request_end_time
Duration session_id ...
00:00:00.0000000139 ...
The duration if it is less than one second, it will always show 00:00:00.0000000. How can I show the MILLISECOND value like 00 00:00:00.050 ?
Thanks,

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

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

Y.B. SSChampion Points: 11649 More actions · Answer 1

Just a stab here but does this work?

select

CONVERT(TIME, DATEADD(ms, DATEDIFF(ms, last_request_start_time, GETDATE()), 0), 114) AS Duration,

*

from sys.dm_exec_sessions

where (status <> 'sleeping' or open_transaction_count > 0)

order by last_request_end_time

SELECT quote FROM brain WHERE original = 1
0 rows returned

yujinagata72 Ten Centuries Points: 1072 More actions · Answer 2

Y.B. (8/2/2016)
Just a stab here but does this work?
select
CONVERT(TIME, DATEADD(ms, DATEDIFF(ms, last_request_start_time, GETDATE()), 0), 114) AS Duration,
*
from sys.dm_exec_sessions
where (status <> 'sleeping' or open_transaction_count > 0)
order by last_request_end_time

Thank you very much!