Post reply

The conversion of the varchar value overflowed an int column

  • November 5, 2019 at 11:23 am

    #3695070

     

    SELECT
      deviceid,
      SUBSTRING(data, 5, 8) AS Daily_Energy,
      SUBSTRING(data, 13, 8) AS Grid_Power,
      SUBSTRING(data, 21, 2) AS alarm,
      SUBSTRING(data, 23, 2) AS status,
      DATEADD(HOUR, 4, EventEnqueuedUtcTime) AS Time,
      CAST(Daily_Energy as float) AS Test


    I tried this query to make Hex Value into Float but itrs giving error 
    please give suggestion on it

    Azure StreamAnalytics Platform

    • This reply was modified 5 years, 1 month ago by  gagan.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply