Good day to all. I have a little problem and I'm sure someone can help me because this forum is great. I need a function or other routine that tell me if a date is reported or not working day???
valeu Galera:-o:-o
SQL> select to_char(sysdate, 'd') from dual;
T
-
2
SQL>
SQL> select case when to_char(sysdate, 'd') in (1,7) then 'FIM DE SEMANA'
2 else 'DIA UTIL'
3 end
4 from dual;
CASEWHENTO_CH
-------------
DIA UTIL
SQL>
SQL> select case when to_char(sysdate+5, 'd') in (1,7) then 'FIM DE SEMANA'
2 else 'DIA UTIL'
3 end
4 from dual;
CASEWHENTO_CH
-------------
FIM DE SEMANA
SQL>
Users browsing this forum: No registered users and 2 guests