<i>SELECT m_datetime,pmi_data FROM v_powerconsumption WHERE pmi_group_e_tarif...

Tomasz Torcz 2017-07-10 19:59 Comments

Tomasz Torcz - 2017-07-10T19:59:21+0000 - Updated: 2017-07-10T19:59:21+0000

SELECT m_datetime,pmi_data FROM v_powerconsumption WHERE pmi_group_e_tariff ='0';
m_datetime │ pmi_data
───────────────────────────────┼─────────────
2017-07-10 21:50:48.976138+02 │ 00015892.91
2017-07-10 21:44:34.946465+02 │ 00015892.87
2017-07-10 21:38:21.125908+02 │ 00015892.83

:-D

Shared with: Public