oracle日期格式

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