User Tools

Site Tools


kurs:zeit_und_intervalle

Differences

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 [2009/09/24 14:17]
mh
kurs:zeit_und_intervalle [2014/09/10 21:22] (current)
Line 1: Line 1:
 +<​code>​
 +select sysdate-to_yminterval('​1-0'​) from dual
  
 +select sysdate-1/​24 from dual;
 +
 +select ( (sysdate-1/​24) - (sysdate-to_dsinterval('​0 02:​30:​00'​)) ) day to second from dual;
 +</​code>​
 +
 +alle angestellten die länger als 12 Jahre "​dabei"​ sind
 +<​code>​
 +select last_name, hire_date, (sysdate - hire_date) year to month as dauer
 + from employees where  hire_date + to_yminterval('​12-0'​) < sysdate
 +order by hire_date desc
 +</​code>​
 +
 +<​code>​
 +select ​ last_day(last_day(sysdate)+1 - to_yminterval('​0-2'​)) from dual;  ​
 +
 +select ADD_MONTHS(sysdate+1,​ -1) from dual
 +</​code>​