How to do MYSQL subtraction

Question

How to do MYSQL subtraction

Navigation

#1 by (0 votes)

0

How to correctly subtract these two columns in the SQL script?

SELECT DISTINCT b.prefixo as idVeiculo,
                max(datatroca) as datatroca, 
                max(kmtroca) as kmtroca,
                max(horimetroca) as horimetroca,
                max(proximatroca) as proximatroca,
                max(c.horimetro) as horimetroatual,
                (a.proximatroca - c.horimetro) as Falta,
                idMecanico FROM oleomotor a
JOIN veiculos b on (a.idVeiculo=b.idVeiculo)
JOIN hodometro c on (a.idVeiculo=c.idVeiculo)
GROUP BY a.idVeiculo order by datatroca DESC;

php mysql sql join select

asked by anonymous 01.05.2018 / 23:45

1 answer

Error running project in Spring math domain error in PYTHON

score 0 · Answer 1

In mysql you should use timediff for comparison of hours:

SELECT DISTINCT b.prefixo as idVeiculo,
                max(datatroca) as datatroca, 
                max(kmtroca) as kmtroca,
                max(horimetroca) as horimetroca,
                max(proximatroca) as proximatroca,
                max(c.horimetro) as horimetroatual,
                timediff(a.proximatroca, c.horimetro) as Falta,
                idMecanico FROM oleomotor a
JOIN veiculos b on (a.idVeiculo=b.idVeiculo)
JOIN hodometro c on (a.idVeiculo=c.idVeiculo)
GROUP BY a.idVeiculo order by datatroca DESC;