User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:zeit_und_intervalle [2010/05/18 11:15] external edit
kurs:zeit_und_intervalle [2014/09/10 21:22] (current)
Line 12: Line 12:
  from employees where  hire_date + to_yminterval('​12-0'​) < sysdate  from employees where  hire_date + to_yminterval('​12-0'​) < sysdate
 order by hire_date desc order by hire_date desc
 +select ​ last_day(last_day(sysdate)+1 - to_yminterval('​0-2'​)) from dual;  ​
 +select ADD_MONTHS(sysdate+1,​ -1) from dual
 </​code>​ </​code>​
kurs/zeit_und_intervalle.txt ยท Last modified: 2014/09/10 21:22 (external edit)