Advertisement
peponloqui

Untitled

Jul 15th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.24 KB | None | 0 0
  1. WITH recursive
  2.   primera_Hora AS --Inicio 1er. CTE
  3.   ( SELECT EXTRACT(HOUR FROM CURRENT_TIME) AS hora_1,
  4.            EXTRACT(MINUTE FROM CURRENT_TIME) AS minuto_1
  5.     FROM rdb$database r
  6.   ), --fin 1er. CTE
  7.   segunda_Hora AS --Inicio 2do. CTE
  8.   ( SELECT EXTRACT(HOUR FROM CURRENT_TIME) AS hora_2,
  9.            EXTRACT(MINUTE FROM CURRENT_TIME) AS minuto_2
  10.     FROM rdb$database r
  11.   ) -- Fin 2do. CTE
  12.   SELECT --Arranca el baile chera'a
  13.     CURRENT_TIME AS hora_minuto_actual,
  14.     CURRENT_TIMESTAMP AS fecha_hora_minuto_actual,
  15.     SUM(PH.HORA_1 + SH.HORA_2) AS TOTAL_HORAS_BASE, --Total de Horas, a secas
  16.     SUM(PH.MINUTO_1 + SH.MINUTO_2) AS TOTAL_MINUTOS_BASE, --Total Minutos, a secas, sin considerar tope de 60
  17.     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.
  18.     CASE --mis minutos finales, dependeran, de si la sumatorio de minutos, paso o no los 59 minutos
  19.       WHEN SUM(PH.MINUTO_1 + SH.MINUTO_2) <= 59 THEN CAST(SUM(PH.MINUTO_1 + SH.MINUTO_2) AS DOUBLE PRECISION)
  20.       ELSE
  21.         SUM(PH.MINUTO_1 + SH.MINUTO_2) - 60
  22.     END minutos_Finales_Calculados_Con_El_Acarreo_A_Horas
  23.   FROM primera_hora ph,
  24.        segunda_hora sh
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement