I searched but did not understand how to use the DATEDIFF () function in FIREBIRD What I need is for the query to return me records with dates up to 10 days prior to the current date .
Note: Understand current date by the day the query is done.
I'll put an example that would work on mysql where I have the best domain, but what I need is an example of what it would look like in FIREBIRD .
select
pag_id as ID,
pag_data_emissao as EMISSAO,
pag_valor AS VALOR,
pag_historico AS HISTORICO,
pag_saldo AS SALDO,
pag_debito_credito as deb_cred
from tab_banco_lanc where pag_data_emissao >= DATE_SUB(curdate(),INTERVAL 10 DAY)