Mercurial > gemma
changeset 5445:0d6fb393c79a marking-single-beam
Merged default into marking-single-beam branch.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 14 Jul 2021 17:46:30 +0200 |
parents | 4046432ccc9d (current diff) 5be842692d87 (diff) |
children | e36cadc51d35 |
files | |
diffstat | 1 files changed, 10 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/report-templates/data-quality-report.yaml Tue Jul 13 18:30:07 2021 +0200 +++ b/report-templates/data-quality-report.yaml Wed Jul 14 17:46:30 2021 +0200 @@ -34,9 +34,11 @@ - type: select statement: > SELECT to_char(d, 'Month YYYY') AS month, d::date - FROM generate_series( '2019-10-01'::date, - now() - interval '1 day', - '1 month'::interval ) d; + FROM generate_series( date_trunc('month', + now() - interval '1 day' + )::date, + '2019-10-01'::date, + - '1 month'::interval ) d; actions: - type: assign name: column_number @@ -89,9 +91,11 @@ - type: select statement: > SELECT to_char(d, 'Month YYYY') AS month, d::date - FROM generate_series( '2019-10-01'::date, - now() - interval '1 day', - '1 month'::interval ) d; + FROM generate_series( date_trunc('month', + now() - interval '1 day' + )::date, + '2019-10-01'::date, + - '1 month'::interval ) d; actions: - type: assign name: column_number