Differences

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

--- kurs:datum [2010/10/28 09:30]
mh
+++ kurs:datum [2014/09/10 21:22] (current)
@@ Line 38: / Line 38: @@
 </code>
+<code>
+select to_char(sysdate, 'yyyymmdd hh24miss')  from dual;
+select sysdate from dual;
+select first_name,
+       last_name
+   --    to_char(hire_date, 'yyyymmdd')
+       from employees
+       where to_char(hire_date, 'yyyy') BETWEEN 1995 and 1997
+       order by hire_date
+       ;
+alter session set NLS_DATE_FORMAT='yyyymmdd'
+select first_name,
+       last_name,
+       to_char(hire_date, 'yyyymmdd')
+       from employees
+       where hire_date
+       BETWEEN to_date('19950101','yyyymmdd') and to_date('19980101','yyyymmdd')
+       order by hire_date
+       ;
+select first_name,
+       last_name,
+       trunc(sysdate - hire_date) tage
+       from employees
+       order by hire_date
+       ;
+select to_char(to_date('2010', 'yyyy'), 'yyyymmdd hh24mi') from dual
+select sysdate-1/24 from dual;
+select extract(month from sysdate) from dual
+select first_name,
+       last_name,
+       to_char(hire_date, 'yyyymmdd')
+       from employees
+       where extract(year from hire_date)
+       BETWEEN 1995 and 1997
+       order by hire_date
+       ;
+</code>

dokuwiki