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