Re: Code does Not Read in FY 2025 Data

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Code does Not Read in FY 2025 Data
Date: 2024-07-16 16:05:29
Message-ID: f40f4b74-c199-42af-8970-85b836cf65d4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/16/24 08:57, Anthony Apollis wrote:
> That very same code is picking up all the data in the Original Table.
> Which only contains past data.

It would.

select CURRENT_DATE;
current_date
--------------
2024-07-16

"Date" < CURRENT_DATE

would return data < 2024-07-16.

You want data that has dates > 2024-07-16.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-07-16 16:25:49 Re: Code does Not Read in FY 2025 Data
Previous Message Anthony Apollis 2024-07-16 15:57:20 Re: Code does Not Read in FY 2025 Data