Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calcular diferença de hora - campo com data e horas juntos

Boa Tarde

Tenho os seguintes campos com conteúdo

inicio = '2016-01-19 10:10:00'

fim = '2016-01-19 13:35:00'

Gostaria de ter o resultado da diferença da horas

resultado= '03:25'

Alguém poderia me ajudar?

Sem mais

Jocélio

1 Solution

Accepted Solutions
Gysbert_Wassenaar

interval(Timestamp#('2016-01-19 13:35:00','YYYY-MM-DD hh:mm:ss')-Timestamp#('2016-01-19 10:10:00','YYYY-MM-DD hh:mm:ss'),'hh:mm')


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

interval(Timestamp#('2016-01-19 13:35:00','YYYY-MM-DD hh:mm:ss')-Timestamp#('2016-01-19 10:10:00','YYYY-MM-DD hh:mm:ss'),'hh:mm')


talk is cheap, supply exceeds demand
Not applicable
Author

Muito Obrigado!! Funcionou certinho!