Convert a date to milliseconds


  • I would like to convert a date to milliseconds to feed a plot chart that I'm using. Can someone tell me where to start. Here's what I tried to do. Please be gentle I come from a Linux background and only have just started using ms sql server.

        SELECT  datediff(ms,date(),a.ReportDate), a.Peak
        from [RealTimeUsage] a
        where exists(
            select top 10 * from
            CustomerPortal.dbo.users b, CustomerPortal.dbo.UsersDevice c
            where (b.useridid = c.useridid) order by a.ReportDate

    • Edited by Ghosteyes999 Wednesday, September 25, 2013 7:41 PM
    Wednesday, September 25, 2013 7:29 PM


All replies