Re: Code does Not Read in FY 2025 Data

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Code does Not Read in FY 2025 Data
Дата
Msg-id f40f4b74-c199-42af-8970-85b836cf65d4@aklaver.com
обсуждение исходный текст
Ответ на Re: Code does Not Read in FY 2025 Data  (Anthony Apollis <anthony.apollis@gmail.com>)
Список 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.klaver@aklaver.com




В списке pgsql-general по дате отправления: