18 lines
595 B
SQL
18 lines
595 B
SQL
/*.open energiemon.db*/
|
|
.mode csv
|
|
.separator ';'
|
|
.header on
|
|
|
|
select id,datetime(zeitpunkt,"localtime")as zeitpunkt,gaszaehler,wetterinfo
|
|
, replace (gasval,'.',',') as gasval
|
|
, replace (vorgasval,'.',',') as vorgasval
|
|
, replace (gasvolumen,'.',',') as gasvolumen
|
|
, replace (zeitspannestd,'.',',') as zeitspannestd
|
|
, replace (gasvolumen24,'.',',') as gasvolumen24
|
|
, replace (gasfaktor,'.',',') as gasfaktor
|
|
, replace (gasverbrauchKWhauf24,'.',',') as gasverbrauchKWhauf24
|
|
, replace (GradCelsiusAussen,'.',',') as GradCelsiusAussen
|
|
|
|
from vgasroh ;
|
|
|