Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH recursive
- primera_Hora AS --Inicio 1er. CTE
- ( SELECT EXTRACT(HOUR FROM CURRENT_TIME) AS hora_1,
- EXTRACT(MINUTE FROM CURRENT_TIME) AS minuto_1
- FROM rdb$database r
- ), --fin 1er. CTE
- segunda_Hora AS --Inicio 2do. CTE
- ( SELECT EXTRACT(HOUR FROM CURRENT_TIME) AS hora_2,
- EXTRACT(MINUTE FROM CURRENT_TIME) AS minuto_2
- FROM rdb$database r
- ) -- Fin 2do. CTE
- SELECT --Arranca el baile chera'a
- CURRENT_TIME AS hora_minuto_actual,
- CURRENT_TIMESTAMP AS fecha_hora_minuto_actual,
- SUM(PH.HORA_1 + SH.HORA_2) AS TOTAL_HORAS_BASE, --Total de Horas, a secas
- SUM(PH.MINUTO_1 + SH.MINUTO_2) AS TOTAL_MINUTOS_BASE, --Total Minutos, a secas, sin considerar tope de 60
- SUM(PH.HORA_1 + SH.HORA_2) + CAST( (SUM(PH.MINUTO_1 + SH.MINUTO_2) / 60) AS INTEGER) AS Horas_Calculadas_con_Saldos_Minutos, --Horas Calculas ... ya con los minutos.
- CASE --mis minutos finales, dependeran, de si la sumatorio de minutos, paso o no los 59 minutos
- WHEN SUM(PH.MINUTO_1 + SH.MINUTO_2) <= 59 THEN CAST(SUM(PH.MINUTO_1 + SH.MINUTO_2) AS DOUBLE PRECISION)
- ELSE
- SUM(PH.MINUTO_1 + SH.MINUTO_2) - 60
- END minutos_Finales_Calculados_Con_El_Acarreo_A_Horas
- FROM primera_hora ph,
- segunda_hora sh
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement