Examples on Date Arithmetic
1. SQL > SELECT EMPNOENAMEJOIN_DT,
ADD MONTHSUOIN DT,12)ANNREV
FROM EMP WHERE DEPTNO = 1;
This query returns a date equal to the given data plus the specified number
of months
2. SQL > COLUMN"Earliest joiner"FORMAT A15
SQL> COLUMN"Earliest joiner"FORMAT A13
SQL > SELECT LEAST(JOIN DT)"Earliest joiner"
2 greatest(join dt)"Lates joiner"
3 FROM emp;
The LEAST function chooses the earliest date from a list of dates, whether
columns or literals; GREATEST chooses the latest date.
I SQL > SELECT ENAME, JOIN DT
2 FROM EMP
3 WHEREjOIN DT BETWEEN '01 JAN 90 AND '01 JAN 95'
4 ORDER BY JOIN DT
The query lists the employees hired between January 1, 1990 and January 1,
1995 in a chronological order.
Domain Name Search
|
