江湖救急:oracle的日期计算问题,在线等待 直接相减就可以的。select to_char(date1,'yyyymmdd')-to_char(data2,'yyyymmdd') from table1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 可以用日期直接加减的 SELECT SYSDATE-1 INTO VAR FROM DUAL 可以用日期直接加减的 SELECT SYSDATE-1 INTO VAR FROM DUAL 你直接减就好了啊 1 select to_date('2002/10/11','yyyy/mm/dd') - 2* to_date('2002/11/06','yyyy/mm/dd') from dualSQL> /TO_DATE('2002/10/11','YYYY/MM/DD')-TO_DATE('2002/11/06','YYYY/MM/DD')--------------------------------------------------------------------- -26SQL> create table temp(a date,b date) ;SQL> insert into temp values(to_date('2002/11/06','yyyy/mm/dd'),to_date('2002/10/06','yyyy/mm/dd'));SQL> commit;SQL> select a -b from temp; A-B---------- 31 SQL> select sysdate-to_date('2002-10-12','yyyy-mm-dd') from dual;SYSDATE-TO_DATE('2002-10-12','YYYY-MM-DD')------------------------------------------ 25.4532523 求触发器 我的数据库需要恢复,急! jpql语言 Oracle数据库 一个临时表和动态sql的问题,高分求教 数据库全文检索方案 就问这是什么错误 java.sql.SQLException: ORA-04031: 无法分配 8192 字节的共享内存 ("large pool","unknown object","sort subheap"
SELECT SYSDATE-1 INTO VAR FROM DUAL
SELECT SYSDATE-1 INTO VAR FROM DUAL
2* to_date('2002/11/06','yyyy/mm/dd') from dual
SQL> /TO_DATE('2002/10/11','YYYY/MM/DD')-TO_DATE('2002/11/06','YYYY/MM/DD')
---------------------------------------------------------------------
-26
SQL> create table temp(a date,b date) ;
SQL> insert into temp values(to_date('2002/11/06','yyyy/mm/dd'),to_date('2002/10/06','yyyy/mm/dd'));SQL> commit;
SQL> select a -b from temp; A-B
----------
31
------------------------------------------
25.4532523