Или еще, кстати
select FIOP,
BIRTHDAY
FROM new_table
WHERE BIRTHDAY between
CAST(CAST((EXTRACT(YEAR FROM current_date) - cast(:X as smallint) - 1) AS char(4)) || '/' || CAST(EXTRACT(MONTH FROM current_date) AS char(2)) || '/' || CAST(EXTRACT(DAY FROM current_date)+1 AS char(2)) AS DATE)
AND
CAST(CAST((EXTRACT(YEAR FROM current_date) - cast(:X as smallint)) AS char(4)) || '/' || CAST(EXTRACT(MONTH FROM current_date) AS char(2)) || '/' || CAST(EXTRACT(DAY FROM current_date) AS char(2)) AS DATE)
|