This shows you the differences between two versions of the page.
kurs:datum [2010/04/16 15:01] mh |
kurs:datum [2014/09/10 21:22] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | alter session set NLS_DATE_FORMAT='yyyymidd'; | ||
- | |||
- | <code> | ||
- | select last_name, hire_date from employees where | ||
- | to_char(hire_date, 'yyyymmdd') | ||
- | between '19980201' and '19980701' | ||
- | / | ||
- | </code> | ||
- | |||
- | nachteil JEDE zeile mu� konvertiert werden | ||
- | |||
- | <code> | ||
- | select last_name, hire_date from employees where | ||
- | hire_date | ||
- | between to_date('19980201', 'yyyymmdd') and to_date('19980701', 'yyyymmdd') | ||
- | / | ||
- | </code> | ||
- | |||
- | <code> | ||
- | select * from ( | ||
- | select first_name, last_name, hire_date, trunc(months_between( sysdate, hire_date)) asd from employees | ||
- | ) | ||
- | where asd >=120 | ||
- | order by hire_date | ||
- | </code> | ||
- | |||
- | Zahl der Tage pro Monat, ACHTUNG das trunc von last_day liefert Mitternacht des letzen Tages, also dauert der Monat dann noch 24h! | ||
- | <code> | ||
- | select (trunc(last_day(sysdate))+1 - trunc(sysdate, 'month')) from dual; | ||
- | </code> | ||
- | |||
- | <code> | ||
- | select add_months(to_date('20090131', 'yyyymmdd'), 1) from dual; | ||
- | </code> | ||