SQL convert time to milliseconds

Question

I have this time-duration: 00:00:23.323 I want to convert it in sql to milliseconds.

EDIT:// I tried this but it isn't very nice:

SELECT  (DATEPART(hh,'12:13:14.123') * 60 * 60 * 1000) SELECT  (DATEPART(n,'12:13:14.123') * 60 * 1000) SELECT  (DATEPART(s,'12:13:14.123') * 1000) SELECT  DATEPART(ms,'12:13:14.123') 

How does it work?

Thanks for your answers.

Answer 1

Use DATEDIFF:

SELECT DATEDIFF(MILLISECOND, 0, '00:00:23.323') 

Result:

23323 

Answer 2

You can use datepart function. like this

select DATEPART(MILLISECOND,GETDATE())+DATEPART(second,getdate())*1000