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,
...

• This reply was modified 5 years, 2 months ago by  gagan.