Function for days

[rcruz]

Good morning everybody. I have a problem and I'm sure someone can help me because this forum is the maximum. Do I need a function or another routine that tells me if an informed date is or not working day ???
valeu Galera: -The: -O

[dr_gori]

Take a look at this link: http://en.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:

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 huh .... I'm doing it right and for the holidays I created a table and a form where they register them and I kill my problem.
This forum is the bixo. :-O