Date calculations in the query

Question

I’ve been having a hard time for some time. I’ve been researching, but I haven’t found anything that would help me.

I need to make a calculation in a query, is the following. I need to take the day the record was entered into the bank and then do an operation with the current date, I have to subtract the current date by the date that was entered into the bank, if the value of the subtraction is greater than 3 , I will know that this record is late. So I need to do this to register my table, and count how many are late. I know I should use COUNT(*) , DATADIFF, INTERVAL, and so on, but I couldn’t. Is it possible ? How would it be ? Thank you.

Answer 1

Follow an example:

SELECT curdate() hoje, Data_operacao
, DATEDIFF(curdate(), Data_operacao) as dias
, (
case 
when DATEDIFF(curdate(), Data_operacao) <= 3 then 0
else (DATEDIFF(curdate(), Data_operacao) - 3)
end 
) dias_atraso
FROM NOME_SUA_TABELA

Total delay is just add the total return of the table.

SELECT 
 sum(
case 
when DATEDIFF(curdate(), Data_operacao) <= 3 then 0
else (DATEDIFF(curdate(), Data_operacao) - 3)
end 
) as TOTAL_atraso
FROM NOME_SUA_TABELA

I hope I’ve helped.

Answer 2

SELECT DATEDIFF(data_operacao, NOW()) AS Diferenca_Dias FROM Tabela

Hence in the language you are using you do the check. If the result you gave is greater than 3 is late.