SQL convert time to milliseconds

sql sql-server time milliseconds
Lingo picture Lingo · Sep 16, 2015 · Viewed 36.8k times · Source

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

t-clausen.dk picture t-clausen.dk · Sep 16, 2015

Use DATEDIFF:

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

Result:

23323

Related questions

Difference between datetime and timestamp in sqlserver?

What is the difference between Timestamp and Datetime SQL Server? I thought Both formats are capable of storing date + time. Then, Where the difference is lying between them? But Timestamp is not capable of storing date, time information. Still Whats …

Read More
How to add minutes to the time part of datetime

How to add minutes(INT) to the time part of datetime ? For example : If i have datetime variable like this : @shift_start_time = 2015-11-01 08:00:00.000 @increase = 30 How to get the result : 2015-11-01 08:30:00.000

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More