Posts by Paul Vernon • 99 points

• -1

  votes

  3

  answers

  80

  views

  A: Doubt with IBM DB2 rule

  This would be a way to get the same result. with cte(regra_job) as (values CASE WHEN HOUR(CURRENT_TIME) < 6 then 4 WHEN HOUR(CURRENT_TIME) < 12 then 1 WHEN HOUR(CURRENT_TIME) < 17 then 2…

  sql database db2 ibm

  answered 4 years, 7 months ago Paul Vernon 99