Postgres Pro
Downloads
Home   >   mailing lists

Electricity bill - Mailing list pgsql-sql

From Theodore M Rolle, Jr.
Subject Electricity bill
Date
Msg-id CAPDmd-CjfhW5pSkthOGmb1rDpznDWYOetrhVh1gcquwQM9n5eA@mail.gmail.com
Whole thread Raw
Responses Re: Electricity bill
Re: Electricity bill
List pgsql-sql
Tree view
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...

pgsql-sql by date:

Previous
From: Ben Tilly
Date:
Subject: Re: losing my mind about sytnax error in window clause
Next
From: Jonathan Katz
Date:
Subject: Re: Electricity bill