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