14 lines
429 B
SQL
14 lines
429 B
SQL
/*.open energiemon.db*/
|
|
.mode csv
|
|
.separator ';'
|
|
.header on
|
|
|
|
select id,datetime(zeitpunkt,"localtime")as zeitpunkt,stromzaehler,wetterinfo
|
|
, replace (stromval,'.',',') as stromval
|
|
, replace (vorstromval,'.',',') as vorstromval
|
|
, replace (stromverzehr,'.',',') as stromverzehr
|
|
, replace (zeitspannestd,'.',',') as zeitspannestd
|
|
, replace (stromverzehr24,'.',',') as stromverzehr24
|
|
from vstromroh ;
|
|
|