Diferença entre datas
Estou necessitando deste select:
SELECT Tab_Doacoes.Doc_Doa_Id, 10 AS Motivo, current_date AS Data, 937 AS Usuario, Tab_Doacoes.Doc_Id
FROM Tab_Doacoes
WHERE (((current_date - doc_data_operacao)>60) AND ((Tab_Doacoes.Doc_Func_Operadora)=937) AND ((Tab_Doacoes.Doc_Status_Doacao)=2))
mas tá dando erro:
´expression evalution not supported´
há alguma forma de remediar isso?
Obrigado
SELECT Tab_Doacoes.Doc_Doa_Id, 10 AS Motivo, current_date AS Data, 937 AS Usuario, Tab_Doacoes.Doc_Id
FROM Tab_Doacoes
WHERE (((current_date - doc_data_operacao)>60) AND ((Tab_Doacoes.Doc_Func_Operadora)=937) AND ((Tab_Doacoes.Doc_Status_Doacao)=2))
mas tá dando erro:
´expression evalution not supported´
há alguma forma de remediar isso?
Obrigado
Fajo
Curtidas 0
Respostas
Sremulador
24/09/2007
Estou necessitando deste select:
SELECT Tab_Doacoes.Doc_Doa_Id, 10 AS Motivo, current_date AS Data, 937 AS Usuario, Tab_Doacoes.Doc_Id
FROM Tab_Doacoes
WHERE (((current_date - doc_data_operacao)>60) AND ((Tab_Doacoes.Doc_Func_Operadora)=937) AND ((Tab_Doacoes.Doc_Status_Doacao)=2))
mas tá dando erro:
´expression evalution not supported´
há alguma forma de remediar isso?
Obrigado
tente
SELECT Tab_Doacoes.Doc_Doa_Id, 10 AS Motivo, current_date AS Data, 937 AS Usuario, Tab_Doacoes.Doc_Id FROM Tab_Doacoes WHERE ((current_date - doc_data_operacao)>60) AND (Tab_Doacoes.Doc_Func_Operadora=937) AND (Tab_Doacoes.Doc_Status_Doacao=2)
GOSTEI 0