MIME-Version: 1.0
References: 
 <CAPDmd-CjfhW5pSkthOGmb1rDpznDWYOetrhVh1gcquwQM9n5eA@mail.gmail.com>
 <4F6F634F-7729-4541-B66A-97D34CA839EA@excoventures.com>
 <CAPDmd-CLcT1RQvRpD4NjMgpOSCO5mYYs2Bctx_MG5U7jiYdsWA@mail.gmail.com>
In-Reply-To: 
 <CAPDmd-CLcT1RQvRpD4NjMgpOSCO5mYYs2Bctx_MG5U7jiYdsWA@mail.gmail.com>
Reply-To: stercor@gmail.com
From: "Theodore M Rolle, Jr." <stercor@gmail.com>
Date: Tue, 7 Jun 2022 21:48:59 -0400
Message-ID: 
 <CAPDmd-ANAvT234d-gsMzhSnQJt_ypGY8S6mOLFWpS92_iiTDKw@mail.gmail.com>
Subject: Fwd: Electricity bill
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b65d8005e0e5e9d5"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPDmd-ANAvT234d-gsMzhSnQJt_ypGY8S6mOLFWpS92_iiTDKw%40mail.gmail.com>
Precedence: bulk

--000000000000b65d8005e0e5e9d5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99 usage? This=
 requires
> retrieving two rows to compute the number of days=E2=80=A6
>
> Based on your description, what I can offer right now is:
>
>         SELECT date_trunc(=E2=80=98month=E2=80=99, date_col), sum(val_col=
);
>
> Jonathan

--000000000000b65d8005e0e5e9d5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Will this compute the interval in days?</div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">---------- Forward=
ed message ---------<br>From: <strong class=3D"gmail_sendername" dir=3D"aut=
o">Theodore M Rolle, Jr.</strong> <span dir=3D"auto">&lt;<a href=3D"mailto:=
stercor@gmail.com">stercor@gmail.com</a>&gt;</span><br>Date: Tue, Jun 7, 20=
22, 21:46<br>Subject: Re: Electricity bill<br>To: Jonathan Katz &lt;<a href=
=3D"mailto:jonathan.katz@excoventures.com">jonathan.katz@excoventures.com</=
a>&gt;<br></div><br><br><div dir=3D"auto">Will this get the current and the=
 last months&#39; dates to compute the interval in days?</div><br><div clas=
s=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jun 7, 2022=
, 21:42 Jonathan Katz &lt;<a href=3D"mailto:jonathan.katz@excoventures.com"=
 target=3D"_blank" rel=3D"noreferrer">jonathan.katz@excoventures.com</a>&gt=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .=
8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
&gt; On Jun 7, 2022, at 9:39 PM, Theodore M Rolle, Jr. &lt;<a href=3D"mailt=
o:stercor@gmail.com" rel=3D"noreferrer noreferrer" target=3D"_blank">sterco=
r@gmail.com</a>&gt; wrote:<br>
&gt; <br>
&gt; I&#39;m putting in YYYY-MM-DD dates of electricity bills and would lik=
e to not have starting and ending dates in the same row. Only ending date.<=
br>
&gt; Will someone show me the SQL to compute the months=E2=80=99 usage? Thi=
s requires retrieving two rows to compute the number of days=E2=80=A6<br>
<br>
Based on your description, what I can offer right now is:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 SELECT date_trunc(=E2=80=98month=E2=80=99, date=
_col), sum(val_col);<br>
<br>
Jonathan</blockquote></div>
</div>

--000000000000b65d8005e0e5e9d5--