Home Forums SQL Server 2014 Development - SQL Server 2014 Converting Hour and Minute to Decimal RE: Converting Hour and Minute to Decimal

  • August 9, 2017 at 7:54 am

    #1954628

    ravikaliappan - Wednesday, August 9, 2017 3:47 AM

    I tried this it doesn't work

    SELECT CONVERT(datetime, 0x17041D49FCC2D488)
    SELECT CONVERT(datetime2, 0x17041D49FCC2D488)

    First, you should start your own thread instead of reopening an old thread.  This one is three years old.

    Second, saying that something doesn't work isn't helpful.  Does fail?  If so, what is the error message?  Does it produce results, but the results are incorrect?  How exactly doesn't it work?

    Finally, you need to give expected results.  It also might help if you indicated where the binary data is coming from.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA