Concatenation of a Select field in the ADDTIME

Question

Concatenation of a Select field in the ADDTIME

Navigation

#1 by (1 votes)

1

"SELECT     at.codigoTurma, "
           "ADDTIME(t.horaInicioCurso, '00:01:00'), "
           "t.toleranciaCurso, "
           "t.horaFinalCurso "
"FROM       AlunosTurmas at "
"INNER JOIN Turmas t "
"ON         t.codigoTurma = at.codigoTurma "
"WHERE      at.matriculaAluno = :matricula "
"ORDER BY   t.horaInicioCurso"

I would like to use the t.toleranciaCurso field, in the ADDTIME function, instead of the minutes.

t.tolerancia(INT), t.horaInicioCurso(TIME).
ADDTIME(t.horaInicioCurso, '00:' + t.toleranciaCurso + ':00') // soma apenas segundos

mysql sql sql-select

asked by anonymous 27.07.2015 / 19:10

1 answer

How to do Split in some specific excepting lines? HttpContext.Current.Request.IsLocal does not work in Startup class

score 1 · Accepted Answer

Since the second parameter of the ADDTIME() function must be of type TIME and you want to use a column dot type INT you need to convert with the function SEC_TO_TIME() :

SEC_TO_TIME(t.toleranciaCurso * 60)

This function waits the number of seconds, as you have minutes, you need to convert to this unit of measure in simple arithmetic.