/*.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 ;