## convert date object into integer

 Author Message j nuñez Ten Centuries Group: General Forum Members Points: 1145 Visits: 279 I continue without understand what you need exactly.Anyway, to obtain the number of miliseconds from a datetime value, you can use something like this:declare @Date DATETIMESET @Date = convert(datetime, '2009-09-01 09:30:15.927')SELECT convert(BIGINT, @Date)* 86400000 SELECT DATEPART(hh, @Date) * 3600000SELECT DATEPART(mi, @Date) * 60000SELECT DATEPART(ss, @Date) * 1000SELECT DATEPART(ms, @Date)SELECT (convert(BIGINT, @Date)* 86400000 ) + (DATEPART(hh, @Date) * 3600000) + (DATEPART(mi, @Date) * 60000) + (DATEPART(ss, @Date) * 1000) + DATEPART(ms, @Date)And, the final result is:Datetime: 2009-09-01 09:30:15.925Number of milisenconds: 3460786215927I hope this can help you. jacob sebastian Ten Centuries Group: General Forum Members Points: 1042 Visits: 2523 If it is a matter of finding the difference between two dates (in milliseconds) you can even run the following query.`DECLARE @d1 DATETIME, @d2 DATETIMESELECT @d1 = '1/9/2008 11:30:24.123', @d2 = '1/10/2008'SELECT DATEDIFF(millisecond, @d1, @d2) AS Diff/*Diff-----------44975877*/`Or you can extract specific information from the date value using the following query and apply your required calculations.`DECLARE @d1 DATETIME, @d2 DATETIMESELECT @d1 = '1/9/2008 11:30:24.123'SELECT DATEPART(year, @d1) AS Years, DATEPART(month, @d1) AS Months, DATEPART(day, @d1) AS Days, DATEPART(hour, @d1) AS Hours, DATEPART(minute, @d1) AS Minutes, DATEPART(second, @d1) AS Seconds, DATEPART(Millisecond, @d1) AS Milliseconds/*Years Months Days Hours Minutes Seconds Milliseconds----------- ----------- ----------- ----------- ----------- ----------- ------------2008 1 9 11 30 24 123*/` .