This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:datum [2009/09/22 12:41] mh |
kurs:datum [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | alter session set NLS_DATE_FORMAT='yyyymidd'; | ||
+ | |||
<code> | <code> | ||
select last_name, hire_date from employees where | select last_name, hire_date from employees where | ||
Line 32: | Line 34: | ||
</code> | </code> | ||
+ | <code> | ||
+ | select to_date('15821004', 'yyyymmdd') + 1 from dual; | ||
+ | </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> |