Fwd: Electricity bill

Will this compute the interval in days?

---------- Forwarded message ---------
From: Theodore M Rolle, Jr. <stercor(at)gmail(dot)com>
Date: Tue, Jun 7, 2022, 21:46
Subject: Re: Electricity bill
To: Jonathan Katz <jonathan(dot)katz(at)excoventures(dot)com>

Will this get the current and the last months' dates to compute the
interval in days?

On Tue, Jun 7, 2022, 21:42 Jonathan Katz <jonathan(dot)katz(at)excoventures(dot)com>
wrote:

>
> > On Jun 7, 2022, at 9:39 PM, Theodore M Rolle, Jr. <stercor(at)gmail(dot)com>
> wrote:
> >
> > I'm putting in YYYY-MM-DD dates of electricity bills and would like to
> not have starting and ending dates in the same row. Only ending date.
> > Will someone show me the SQL to compute the months’ usage? This requires
> retrieving two rows to compute the number of days…
>
> Based on your description, what I can offer right now is:
>
> SELECT date_trunc(‘month’, date_col), sum(val_col);
>
> Jonathan