Electricity bill

From: "Theodore M Rolle, Jr(dot)" <stercor(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Electricity bill
Date: 2022-06-08 01:39:09
Message-ID: CAPDmd-CjfhW5pSkthOGmb1rDpznDWYOetrhVh1gcquwQM9n5eA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jonathan Katz 2022-06-08 01:42:27 Re: Electricity bill
Previous Message Ben Tilly 2022-06-08 00:48:53 Re: losing my mind about sytnax error in window clause