select select select select
28.更新时间
floor(to_number(sysdate-to_date('2007-11-02 floor(to_number(sysdate-to_date('2007-11-02 floor(to_number(sysdate-to_date('2007-11-02 floor(to_number(sysdate-to_date('2007-11-02
15:55:03','yyyy-mm-dd 15:55:03','yyyy-mm-dd 15:55:03','yyyy-mm-dd 15:55:03','yyyy-mm-dd
hh24:mi:ss'))) as spanDays from dual //时间差-天 hh24:mi:ss'))*24) as spanHours from dual //时间差-时 hh24:mi:ss'))*24*60) as spanMinutes from dual //时间差-分 hh24:mi:ss'))*24*60*60) as spanSeconds from dual //时间差-秒
注:oracle时间加减是以天数为单位,设改变量为n,所以换算成年月,日 select //改变时间-年
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),add_months(sysdate,n) as newTime from dual //改变时间-月
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),to_char(sysdate+n,'yyyy-mm-dd hh24:mi:ss') as newTime from dual //改变时间-日 select //改变时间-时 select //改变时间-分 select
dual //改变时间-秒
29.查找月的第一天,最后一天
SELECT Trunc(Trunc(SYSDATE, 'MONTH') - 1, 'MONTH') First_Day_Last_Month, Trunc(SYSDATE, 'MONTH') - 1 / 86400 Last_Day_Last_Month, Trunc(SYSDATE, 'MONTH') First_Day_Cur_Month,
LAST_DAY(Trunc(SYSDATE, 'MONTH')) + 1 - 1 / 86400 Last_Day_Cur_Month FROM dual;
to_char(sysdate,'yyyy-mm-dd
hh24:mi:ss'),to_char(sysdate+n/24/60/60,'yyyy-mm-dd hh24:mi:ss') as newTime from
to_char(sysdate,'yyyy-mm-dd
hh24:mi:ss'),to_char(sysdate+n/24/60,'yyyy-mm-dd hh24:mi:ss') as newTime from dual
to_char(sysdate,'yyyy-mm-dd
hh24:mi:ss'),to_char(sysdate+n/24,'yyyy-mm-dd hh24:mi:ss') as newTime from dual
to_char(sysdate,'yyyy-mm-dd
hh24:mi:ss'),to_char(sysdate+n*365,'yyyy-mm-dd hh24:mi:ss') as newTime from dual
