Function to working days

[rcruz]

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

[dr_gori]

Take a look at this link: http://www.glufke.net/oracle/viewtopic.php?t=22 you can use TO_CHAR to find out the day of the week. (1 = Sunday, 7 = Saturday).
See example:

Code: Select all

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>


[rcruz]

Thanks é .... I'm doing exactly that and for the holidays I created a table and a forms where they record and Bush once my problem.
This forum is the dude.