Advertisement
lucasmouraahere

Função Oracle NEXT DAY

Jun 27th, 2019
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.28 KB | None | 0 0
  1. SELECT NEXT_DAY(TO_DATE('01/07/2017', 'DD/MM/YY'), 'SUNDAY') AS prox_sabado,
  2.        NEXT_DAY(TO_DATE('29/06/2017', 'DD/MM/YY'), 'SAT') AS prox_quinta
  3.   FROM dual;
  4.  
  5. SUNDAY  - SUN
  6. MONDAY  - MON
  7. TUESDAY  - TUE
  8. WEDNESDAY- WED
  9. THURSDAY - THU
  10. FRIDAY  - FRI
  11. SATURDAY - SAT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement