The Spirit-Informasi: Function Date "Query oracle9i "/ ISQL PLUS

select sysdate,start_date, months_between(sysdate,start_date)from s_emp

SYSDATE	START_DAT	MONTHS_BETWEEN(SYSDATE,START_DATE)
18-MAR-09	03-MAR-90	228.491997
18-MAR-09	08-MAR-90	228.342131
18-MAR-09	17-JUN-91	213.051809
18-MAR-09	07-APR-90	227.37439
18-MAR-09	04-MAR-90	228.471164
18-MAR-09	18-JAN-91	218
18-MAR-09	14-MAY-90	226.148583
18-MAR-09	07-APR-90	227.37439
18-MAR-09	09-FEB-92	205.309873
18-MAR-09	27-FEB-91	216.729228
18-MAR-09	14-MAY-90	226.148583
18-MAR-09	18-JAN-92	206
18-MAR-09	18-FEB-91	217
18-MAR-09	22-JAN-92	205.890519
SYSDATE	START_DAT	MONTHS_BETWEEN(SYSDATE,START_DATE)
18-MAR-09	09-OCT-91	209.309873
18-MAR-09	07-FEB-92	205.37439
18-MAR-09	08-MAR-90	228.342131
18-MAR-09	09-FEB-91	217.309873
18-MAR-09	06-AUG-91	211.406648
18-MAR-09	21-JUL-91	211.922777
18-MAR-09	26-MAY-91	213.761486
18-MAR-09	30-NOV-90	219.632454
18-MAR-09	17-OCT-90	221.051809
18-MAR-09	17-MAR-91	216.051809
18-MAR-09	09-MAY-91	214.309873

select sysdate,add_months(sysdate,8)from s_emp

3.select sysdate,next_day(sysdate,'saturday')from s_emp

18-MAR-09 21-MAR-09

4.select sysdate,last_day(sysdate)from s_emp

18-MAR-09 31-MAR-09

select sysdate,round(sysdate,'Month')as ROUND_MONTH from s_emp

select sysdate,round(sysdate,'Year')as ROUND_YEAR from s_emp

select sysdate,trunc(sysdate,'Month')as TRUNC_MONTH from s_emp

select sysdate,trunc(sysdate,'Year')as TRUNC_YEAR from s_emp

The Spirit-Informasi