Tengo esta table de lecturas cada 15 minutos. Quiero convertirla a una por día, por ejemplo a las 09:00:00.
Qué debo hacer?
<colgroup><col width="192" style="width: 144pt;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Qué debo hacer?
READINGDATE | AVG |
2016-01-01 00:00:00 | 501.1322 |
2016-01-01 00:15:00 | 501.1432 |
2016-01-01 00:30:00 | 501.1235 |
2016-01-01 00:45:00 | 501.1046 |
2016-01-01 01:00:00 | 501.1276 |
2016-01-01 01:15:00 | 501.1499 |
2016-01-01 01:30:00 | 501.1407 |
2016-01-01 01:45:00 | 501.1447 |
2016-01-01 02:00:00 | 501.1361 |
2016-01-01 02:15:00 | 501.1318 |
2016-01-01 02:30:00 | 501.159 |
2016-01-01 02:45:00 | 501.1746 |
2016-01-01 03:00:00 | 501.1606 |
2016-01-01 03:15:00 | 501.145 |
2016-01-01 03:30:00 | 501.1512 |
2016-01-01 03:45:00 | 501.1656 |
2016-01-01 04:00:00 | 501.1748 |
2016-01-01 04:15:00 | 501.2027 |
2016-01-01 04:30:00 | 501.1875 |
2016-01-01 04:45:00 | 501.1583 |
2016-01-01 05:00:00 | 501.1706 |
2016-01-01 05:15:00 | 501.2023 |
2016-01-01 05:30:00 | 501.2142 |
2016-01-01 05:45:00 | 501.187 |
2016-01-01 06:00:00 | 501.1858 |
2016-01-01 06:15:00 | 501.1862 |
2016-01-01 06:30:00 | 501.1941 |
2016-01-01 06:45:00 | 501.2324 |
2016-01-01 07:00:00 | 501.2255 |
2016-01-01 07:15:00 | 501.1902 |
2016-01-01 07:30:00 | 501.2071 |
2016-01-01 07:45:00 | 501.2401 |
2016-01-01 08:00:00 | 501.2562 |
2016-01-01 08:15:00 | 501.2178 |
2016-01-01 08:30:00 | 501.2023 |
2016-01-01 08:45:00 | 501.2183 |
2016-01-01 09:00:00 | 501.2467 |
2016-01-01 09:15:00 | 501.2579 |
2016-01-01 09:30:00 | 501.2495 |
2016-01-01 09:45:00 | 501.2348 |
2016-01-01 10:00:00 | 501.2403 |
2016-01-01 10:15:00 | 501.265 |
2016-01-01 10:30:00 | 501.2674 |
2016-01-01 10:45:00 | 501.2603 |
2016-01-01 11:00:00 | 501.2475 |
2016-01-01 11:15:00 | 501.2537 |
2016-01-01 11:30:00 | 501.2685 |
2016-01-01 11:45:00 | 501.2903 |
2016-01-01 12:00:00 | 501.2854 |
2016-01-01 12:15:00 | 501.268 |
2016-01-01 12:30:00 | 501.2832 |
2016-01-01 12:45:00 | 501.305 |
2016-01-01 13:00:00 | 501.3136 |
2016-01-01 13:15:00 | 501.3031 |
2016-01-01 13:30:00 | 501.2968 |
2016-01-01 13:45:00 | 501.2967 |
2016-01-01 14:00:00 | 501.3072 |
2016-01-01 14:15:00 | 501.3211 |
2016-01-01 14:30:00 | 501.3192 |
2016-01-01 14:45:00 | 501.3226 |
2016-01-01 15:00:00 | 501.3244 |
2016-01-01 15:15:00 | 501.3294 |
2016-01-01 15:30:00 | 501.3394 |
2016-01-01 15:45:00 | 501.3236 |
2016-01-01 16:00:00 | 501.3239 |
2016-01-01 16:15:00 | 501.3349 |
2016-01-01 16:30:00 | 501.3519 |
2016-01-01 16:45:00 | 501.3501 |
2016-01-01 17:00:00 | 501.3506 |
2016-01-01 17:15:00 | 501.3552 |
2016-01-01 17:30:00 | 501.3633 |
2016-01-01 17:45:00 | 501.3681 |
2016-01-01 18:00:00 | 501.3605 |
2016-01-01 18:15:00 | 501.3634 |
2016-01-01 18:30:00 | 501.3834 |
2016-01-01 18:45:00 | 501.3691 |
2016-01-01 19:00:00 | 501.3759 |
2016-01-01 19:15:00 | 501.3632 |
2016-01-01 19:30:00 | 501.3758 |
2016-01-01 19:45:00 | 501.3942 |
2016-01-01 20:00:00 | 501.3962 |
2016-01-01 20:15:00 | 501.3897 |
2016-01-01 20:30:00 | 501.399 |
2016-01-01 20:45:00 | 501.4101 |
2016-01-01 21:00:00 | 501.4022 |
2016-01-01 21:15:00 | 501.4007 |
2016-01-01 21:30:00 | 501.4123 |
2016-01-01 21:45:00 | 501.4044 |
2016-01-01 22:00:00 | 501.4194 |
2016-01-01 22:15:00 | 501.4293 |
2016-01-01 22:30:00 | 501.4376 |
2016-01-01 22:45:00 | 501.4217 |
2016-01-01 23:00:00 | 501.4305 |
2016-01-01 23:15:00 | 501.4445 |
2016-01-01 23:30:00 | 501.4419 |
2016-01-01 23:45:00 | 501.4388 |
2016-01-02 00:00:00 | 501.4511 |
2016-01-02 00:15:00 | 501.4524 |
2016-01-02 00:30:00 | 501.4397 |
2016-01-02 00:45:00 | 501.4591 |
2016-01-02 01:00:00 | 501.4715 |
2016-01-02 01:15:00 | 501.4758 |
2016-01-02 01:30:00 | 501.482 |
2016-01-02 01:45:00 | 501.4602 |
2016-01-02 02:00:00 | 501.4667 |
2016-01-02 02:15:00 | 501.4802 |
2016-01-02 02:30:00 | 501.5069 |
2016-01-02 02:45:00 | 501.5096 |
2016-01-02 03:00:00 | 501.4975 |
2016-01-02 03:15:00 | 501.493 |
2016-01-02 03:30:00 | 501.4945 |
2016-01-02 03:45:00 | 501.5166 |
2016-01-02 04:00:00 | 501.527 |
2016-01-02 04:15:00 | 501.5346 |
2016-01-02 04:30:00 | 501.5241 |
2016-01-02 04:45:00 | 501.5094 |
2016-01-02 05:00:00 | 501.5164 |
2016-01-02 05:15:00 | 501.5398 |
2016-01-02 05:30:00 | 501.5619 |
2016-01-02 05:45:00 | 501.5466 |
2016-01-02 06:00:00 | 501.5378 |
2016-01-02 06:15:00 | 501.5386 |
2016-01-02 06:30:00 | 501.5583 |
2016-01-02 06:45:00 | 501.5711 |
2016-01-02 07:00:00 | 501.5625 |
2016-01-02 07:15:00 | 501.5628 |
2016-01-02 07:30:00 | 501.5552 |
2016-01-02 07:45:00 | 501.5646 |
2016-01-02 08:00:00 | 501.5869 |
2016-01-02 08:15:00 | 501.6023 |
2016-01-02 08:30:00 | 501.5922 |
2016-01-02 08:45:00 | 501.576 |
2016-01-02 09:00:00 | 501.5908 |
2016-01-02 09:15:00 | 501.6023 |
2016-01-02 09:30:00 | 501.6064 |
2016-01-02 09:45:00 | 501.6081 |
2016-01-02 10:00:00 | 501.6134 |
2016-01-02 10:15:00 | 501.6018 |
2016-01-02 10:30:00 | 501.6039 |
2016-01-02 10:45:00 | 501.6196 |
2016-01-02 11:00:00 | 501.642 |
2016-01-02 11:15:00 | 501.6395 |
2016-01-02 11:30:00 | 501.625 |
2016-01-02 11:45:00 | 501.6222 |
2016-01-02 12:00:00 | 501.6444 |
2016-01-02 12:15:00 | 501.651 |
2016-01-02 12:30:00 | 501.652 |
2016-01-02 12:45:00 | 501.6549 |
2016-01-02 13:00:00 | 501.657 |
2016-01-02 13:15:00 | 501.6675 |
2016-01-02 13:30:00 | 501.6767 |
2016-01-02 13:45:00 | 501.6785 |
2016-01-02 14:00:00 | 501.684 |
2016-01-02 14:15:00 | 501.6789 |
2016-01-02 14:30:00 | 501.6802 |
2016-01-02 14:45:00 | 501.6859 |
2016-01-02 15:00:00 | 501.7063 |
2016-01-02 15:15:00 | 501.7094 |
2016-01-02 15:30:00 | 501.6929 |
2016-01-02 15:45:00 | 501.6932 |
2016-01-02 16:00:00 | 501.7115 |
2016-01-02 16:15:00 | 501.7325 |
2016-01-02 16:30:00 | 501.7081 |
2016-01-02 16:45:00 | 501.723 |
2016-01-02 17:00:00 | 501.7329 |
2016-01-02 17:15:00 | 501.7318 |
2016-01-02 17:30:00 | 501.7484 |
2016-01-02 17:45:00 | 501.7508 |
2016-01-02 18:00:00 | 501.7476 |
2016-01-02 18:15:00 | 501.7355 |
2016-01-02 18:30:00 | 501.753 |
2016-01-02 18:45:00 | 501.7728 |
2016-01-02 19:00:00 | 501.7898 |
2016-01-02 19:15:00 | 501.7685 |
2016-01-02 19:30:00 | 501.7595 |
2016-01-02 19:45:00 | 501.7991 |
2016-01-02 20:00:00 | 501.7815 |
2016-01-02 20:15:00 | 501.7943 |
2016-01-02 20:30:00 | 501.8009 |
2016-01-02 20:45:00 | 501.8235 |
2016-01-02 21:00:00 | 501.8235 |
2016-01-02 21:15:00 | 501.8104 |
2016-01-02 21:30:00 | 501.8199 |
2016-01-02 21:45:00 | 501.8252 |
2016-01-02 22:00:00 | 501.8242 |
2016-01-02 22:15:00 | 501.8508 |
2016-01-02 22:30:00 | 501.8449 |
2016-01-02 22:45:00 | 501.847 |
2016-01-02 23:00:00 | 501.8419 |
2016-01-02 23:15:00 | 501.8576 |
2016-01-02 23:30:00 | 501.8726 |
2016-01-02 23:45:00 | 501.8784 |
2016-01-03 00:00:00 | 501.8692 |
2016-01-03 00:15:00 | 501.8737 |
2016-01-03 00:30:00 | 501.8761 |
2016-01-03 00:45:00 | 501.8929 |
2016-01-03 01:00:00 | 501.8812 |
2016-01-03 01:15:00 | 501.8928 |
2016-01-03 01:30:00 | 501.8887 |
2016-01-03 01:45:00 | 501.8948 |
2016-01-03 02:00:00 | 501.9 |
2016-01-03 02:15:00 | 501.9034 |
2016-01-03 02:30:00 | 501.9045 |
2016-01-03 02:45:00 | 501.9067 |
2016-01-03 03:00:00 | 501.9086 |
2016-01-03 03:15:00 | 501.9273 |
2016-01-03 03:30:00 | 501.9265 |
2016-01-03 03:45:00 | 501.9245 |
2016-01-03 04:00:00 | 501.94 |
2016-01-03 04:15:00 | 501.9506 |
2016-01-03 04:30:00 | 501.9212 |
2016-01-03 04:45:00 | 501.93 |
2016-01-03 05:00:00 | 501.9417 |
2016-01-03 05:15:00 | 501.9498 |
2016-01-03 05:30:00 | 501.9723 |
2016-01-03 05:45:00 | 501.9477 |
2016-01-03 06:00:00 | 501.9427 |
2016-01-03 06:15:00 | 501.9681 |
2016-01-03 06:30:00 | 501.9815 |
2016-01-03 06:45:00 | 501.9485 |
2016-01-03 07:00:00 | 501.9541 |
2016-01-03 07:15:00 | 501.9751 |
2016-01-03 07:30:00 | 501.9916 |
2016-01-03 07:45:00 | 501.9621 |
2016-01-03 08:00:00 | 501.9589 |
2016-01-03 08:15:00 | 501.9709 |
2016-01-03 08:30:00 | 502.0017 |
2016-01-03 08:45:00 | 501.9962 |
2016-01-03 09:00:00 | 502.0028 |
2016-01-03 09:15:00 | 501.9843 |
2016-01-03 09:30:00 | 502.0007 |
2016-01-03 09:45:00 | 501.9989 |
2016-01-03 10:00:00 | 502.0242 |
2016-01-03 10:15:00 | 502.011 |
2016-01-03 10:30:00 | 502.0099 |
2016-01-03 10:45:00 | 501.9942 |
2016-01-03 11:00:00 | 502.0184 |
2016-01-03 11:15:00 | 501.9961 |
2016-01-03 11:30:00 | 502.0255 |
2016-01-03 11:45:00 | 502.0362 |
2016-01-03 12:00:00 | 502.029 |
2016-01-03 12:15:00 | 502.0106 |
2016-01-03 12:30:00 | 502.046 |
2016-01-03 12:45:00 | 502.0741 |
2016-01-03 13:00:00 | 502.0272 |
2016-01-03 13:15:00 | 502.0518 |
2016-01-03 13:30:00 | 502.0671 |
2016-01-03 13:45:00 | 502.0597 |
2016-01-03 14:00:00 | 502.0709 |
2016-01-03 14:15:00 | 502.049 |
2016-01-03 14:30:00 | 502.0894 |
2016-01-03 14:45:00 | 502.057 |
2016-01-03 15:00:00 | 502.03 |
2016-01-03 15:15:00 | 502.038 |
2016-01-03 15:30:00 | 502.0789 |
2016-01-03 15:45:00 | 502.1099 |
2016-01-03 16:00:00 | 502.1208 |
2016-01-03 16:15:00 | 502.109 |
2016-01-03 16:30:00 | 502.0808 |
2016-01-03 16:45:00 | 502.0705 |
2016-01-03 17:00:00 | 502.1018 |
2016-01-03 17:15:00 | 502.1115 |
2016-01-03 17:30:00 | 502.1216 |
2016-01-03 17:45:00 | 502.1195 |
2016-01-03 18:00:00 | 502.1144 |
2016-01-03 18:15:00 | 502.1211 |
2016-01-03 18:30:00 | 502.1348 |
2016-01-03 18:45:00 | 502.1453 |
2016-01-03 19:00:00 | 502.1478 |
2016-01-03 19:15:00 | 502.13 |
2016-01-03 19:30:00 | 502.11 |
2016-01-03 19:45:00 | 502.124 |
2016-01-03 20:00:00 | 502.1618 |
2016-01-03 20:15:00 | 502.1575 |
2016-01-03 20:30:00 | 502.1431 |
2016-01-03 20:45:00 | 502.1257 |
2016-01-03 21:00:00 | 502.1497 |
2016-01-03 21:15:00 | 502.1562 |
2016-01-03 21:30:00 | 502.1811 |
2016-01-03 21:45:00 | 502.1753 |
2016-01-03 22:00:00 | 502.1712 |
2016-01-03 22:15:00 | 502.1623 |
2016-01-03 22:30:00 | 502.1669 |
2016-01-03 22:45:00 | 502.1801 |
2016-01-03 23:00:00 | 502.2028 |
2016-01-03 23:15:00 | 502.1904 |
2016-01-03 23:30:00 | 502.1952 |
2016-01-03 23:45:00 | 502.1758 |