Fórum Como esta view do Sql Server ficará no Firebird? #39222

caros colegas,
como fica esta view do Sql Server no Firebird?

Create view vwTbcliInadimplente as
Select
data=sum(convert(integer,isnull(TbCtRec.DtQuitCtRec,getdate()-1))-convert(integer,isnull(TbCtRec.DtProrrogCtRec,TbCtRec.DtVctoCtRec))),
dt_atual= isnull(TbCtRec.DtProrrogCtRec,TbCtRec.DtVctoCtRec),
tbctrec.DtLctoCtRec,tbctrec.DtVctoCtRec,TbCtRec.DtProrrogCtRec,TbCtRec.DtQuitCtRec,TbCtRec.NrLctoCtRec,TbCtRec.ctDevCtRec,TbCtRec.codEspdocCtrec,
TbCtRec.codSeriedocctrec, TbCtRec.Nrdocctrec,TbCtRec.NrParcDocCtRec,Tbctrec.TotParcDocCtRec,TBCtRec.RestDocCtRec,TbCtRec.ValCtRec,SitCtRec,
TbCli.CodEmpr, TBcli.CodRedCt,tbcli.RzsCli,tbcli.NomeFantCli,Tbcli.CodSegCli,Tbcli.CodTerritCli,Tbcli.CodRotaTerritCli,tbcli.TpCtCli
from TbCtRec
left outer join TBCli on
(TbCtRec.CodEmpr=TBCli.CodEmpr and
TbCtRec.CtDevCtRec = TBcli.CodRedCt)
where TbCtrec.SitCtRec=´R´
group by
tbctrec.DtLctoCtRec,tbctrec.DtVctoCtRec,TbCtRec.DtProrrogCtRec,TbCtRec.DtQuitCtRec,TbCtRec.NrLctoCtRec,TbCtRec.ctDevCtRec,TbCtRec.codEspdocCtrec,
TbCtRec.codSeriedocctrec, TbCtRec.Nrdocctrec,TbCtRec.NrParcDocCtRec,Tbctrec.TotParcDocCtRec,TBCtRec.RestDocCtRec,TbCtRec.ValCtRec,SitCtRec,
TbCli.CodEmpr, TBcli.CodRedCt,tbcli.RzsCli,tbcli.NomeFantCli,Tbcli.CodSegCli,Tbcli.CodTerritCli,Tbcli.CodRotaTerritCli,tbcli.TpCtCli


Estou migrando minha base de dados em Sql Server para Firebird e com isso tenho esse problemas, pois não conheço a estrutura do firebird. Alguém pode me ajudar? OBrigado,