Postgres Pro
Downloads
Home   >   mailing lists

Re: Code does Not Read in FY 2025 Data - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Code does Not Read in FY 2025 Data
Date
Msg-id f40f4b74-c199-42af-8970-85b836cf65d4@aklaver.com
Whole thread Raw
In response to Re: Code does Not Read in FY 2025 Data  (Anthony Apollis <anthony.apollis@gmail.com>)
List pgsql-general
Tree view 
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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Anthony Apollis
Date:
Subject: Re: Code does Not Read in FY 2025 Data
Next
From: "David G. Johnston"
Date:
Subject: Re: Code does Not Read in FY 2025 Data