SELECT * FROM Employees 
     WHERE dob = CURRENT_DATE

дд / мм / гггг

SELECT
 * 
FROM
 <таблица>
WHERE
 <поле> = (CURRENT_DATE- 1 )

select
 Title,dBeg,dEnd,dSet
from
 wrk.Stage
where
 dSet>(CURRENT_DATE- 10 )

Include ft

/// Этапы
Class wrk.Stage Extends (%Persistent, %ZEN.DataModel.Adaptor)
{

/// Начало
Property dBeg As %Date(FORMAT =  3 );

/// Окончание
Property dEnd As %Date(FORMAT =  3 );

/// Исполнитель
Relationship Member As wrk.Member [ Cardinality = one, Inverse = Stage ];

Index MemberIndex On Member;

/// Описание выполненых работ
Property Text As %Text(LANGUAGECLASS = "%Text.Russian", MAXLEN =  4000 );

/// Название этапа
Property Title As %String(MAXLEN =  200 );

/// Связь с работой
Relationship Job As wrk.Job [ Cardinality = one, Inverse = Stage ];

Index JobIndex On Job;

/// Связь с целью
Relationship Purpose As wrk.Purpose [ Cardinality = one, Inverse = Stage ];

Index PurposeIndex On Purpose;

/// Установлена в версию
Property dSet As %Date(FORMAT =  3 );

/// Состав, список измененных элементов
Property Structure As %String(MAXLEN =  1000 );

/// Связь с отчетами за месяц
Relationship RepMon As wrk.RepMon [ Cardinality = one, Inverse = Stage ];

Index RepMonIndex On RepMon;

/// Не брать в отчет за месяц
Property RepBlock As %Boolean;

Relationship Grading As wrk.Grading [ Cardinality = one, Inverse = Stage ];

Index GradingIndex On Grading;

/// Приоритет для месячного отчета
Property RepPrio As %Integer;

Relationship Vers As wrk.Vers [ Cardinality = one, Inverse = Stage ];

Index VersIndex On Vers;

/// Не брать в состав версии
Property VersBlock As %Boolean;

}

SELECT
 <поле>- 1 
FROM
 <таблица>
 

SELECT DISTINCT
 CURRENT_DATE,
 TO_DATE(CURRENT_DATE,'MM/DD/YYYY'),
 TO_DATE(CURRENT_DATE,'MM/DD/YYYY')- 1 
FROM
 <таблица>