¨C»ñÈ¡Á½Ê±¼äµÄÏà²îºÀÃëÊý
select ceil((To_date(¡¯2008-05-02 00:00:00¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯) ¨C To_date(¡¯2008-04-30 23:59:59¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯)) * 24 * 60 * 60 * 1000) Ïà²îºÀÃëÊý FROM DUAL;
/*
Ïà²îºÀÃëÊý
¡ª¡ª¡ª-
86401000
1 row selected
*/
¨C»ñÈ¡Á½Ê±¼äµÄÏà²îÃëÊý
select ceil((To_date(¡¯2008-05-02 00:00:00¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯) ¨C To_date(¡¯2008-04-30 23:59:59¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯)) * 24 * 60 * 60) Ïà²îÃëÊý FROM DUAL;
/*
Ïà²îÃëÊý
¡ª¡ª¡ª-
86401
1 row selected
*/
¨C»ñÈ¡Á½Ê±¼äµÄÏà²î·ÖÖÓÊý
select ceil(((To_date(¡¯2008-05-02 00:00:00¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯) ¨C To_date(¡¯2008-04-30 23:59:59¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯))) * 24 * 60) Ïà²î·ÖÖÓÊý FROM DUAL;
/*
Ïà²î·ÖÖÓÊý
¡ª¡ª¡ª-
1441
1 row selected
*/
¨C»ñÈ¡Á½Ê±¼äµÄÏà²îСʱÊý
select ceil((To_date(¡¯2008-05-02 00:00:00¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯) ¨C To_date(¡¯2008-04-30 23:59:59¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯)) * 24) Ïà²îСʱÊý FROM DUAL;
/*
Ïà²îСʱÊý
¡ª¡ª¡ª-
25
1 row selected
*/
¨C»ñÈ¡Á½Ê±¼äµÄÏà²îÌìÊý
select ceil((To_date(¡¯2008-05-02 00:00:00¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯) ¨C To_date(¡¯2008-04-30 23:59:59¡ä , ¡®yyyy-mm-dd hh24-mi-ss¡¯))) Ïà²îÌìÊý FROM DUAL;
/*
Ïà²îÌìÊý
¡ª¡ª¡ª-
2
1 row selected
*/
¨C»ñÈ¡Á½Ê±¼äÔ·ݲî
select (EXTRACT(year FROM to_date(¡¯2009-05-01¡ä,¡¯yyyy-mm-dd¡¯)) ¨C EXTRACT(year FROM to_date(¡¯2008-04-30¡ä,¡¯yyyy-mm-dd¡¯))) * 12 +
EXTRACT(month FROM to_date(¡¯2008-05-01¡ä,¡¯yyyy-mm-dd¡¯)) ¨C EXTRACT(month FROM to_date(¡¯2008-04-30¡ä,¡¯yyyy-mm-dd¡¯)) months
from dual;
/*MONTHS¡ª¡ª¡ª- 131 row selected*/
¨C»ñÈ¡Á½Ê±¼äÄê·Ý²î
select EXTRACT(year FROM to_date(¡¯2009-05-01¡ä,¡¯yyyy-mm-dd¡¯)) ¨C EXTRACT(year FROM to_date(¡¯2008-04-30¡ä,¡¯yyyy-mm-dd¡¯)) years from dual;
/*
YEARS
¡ª¡ª¡ª-
1
1 row selected