Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Electricity bill - Mailing list pgsql-sql

From Theodore M Rolle, Jr.
Subject Fwd: Electricity bill
Date
Msg-id CAPDmd-ANAvT234d-gsMzhSnQJt_ypGY8S6mOLFWpS92_iiTDKw@mail.gmail.com
Whole thread Raw
In response to Electricity bill  ("Theodore M Rolle, Jr." <stercor@gmail.com>)
List pgsql-sql
Tree view
Will this compute the interval in days?

---------- Forwarded message ---------
From: Theodore M Rolle, Jr. <stercor@gmail.com>
Date: Tue, Jun 7, 2022, 21:46
Subject: Re: Electricity bill
To: Jonathan Katz <jonathan.katz@excoventures.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.katz@excoventures.com> wrote:

> On Jun 7, 2022, at 9:39 PM, Theodore M Rolle, Jr. <stercor@gmail.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

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Electricity bill
Next
From: Joe Conway
Date:
Subject: Re: Electricity bill