select case
       when sysdate = trunc(sysdate) then 0
       when 1 = 1 then case when to_char(sysdate, 'd') = 4 then 1 else -1 end
       else 99
       end
  from dual;