lucasmouraahere

Função Oracle LAST DAY

Jun 26th, 2019
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.33 KB | None | 0 0
  1. -- RETORNA O ULTIMO DIA DO MÊS
  2.  
  3. SELECT TRUNC(SYSDATE) AS Data_atual,
  4.        LAST_DAY(TRUNC(SYSDATE)) AS ultimo_dia_mes
  5.   FROM dual;
  6.  
  7. SELECT LAST_DAY(TO_DATE('10/02/2016', 'DD/MM/YY')) AS ultimo_dia_mes
  8.   FROM dual;
  9.  
  10. SELECT hire_date, LAST_DAY(hire_date) AS Ultimo_dia_mes
  11.   FROM hr.employees
  12.  WHERE employee_id =114;
Advertisement
Add Comment
Please, Sign In to add comment