日期函数-oracle数据库操作

时间:2024-05-16 03:16:13
【文件属性】:

文件名称:日期函数-oracle数据库操作

文件大小:1.19MB

文件格式:PPT

更新时间:2024-05-16 03:16:13

ppt

日期函数 ADD_MONTHS 示例: SELECT delDate,add_months(delDate,2) FROM orderMaster; Last_day 示例: SELECT SYSDATE,last_date(delDate) FROM orderMaster WHERE odate > ’01-dec-11’; Months_between 示例: SELECT months_between(delDate,odate) FROM orderMaster; Round 示例: SELECT delDate,round(delDate,’year’) FROM orderMaster WHERE vencode=‘V001’; SELECT delDate,round(delDate,‘month’) FROM orderMaster WHERE vencode=‘V001’; SELECT odate,round(odate,’day’) FROM orderMaster WHERE vencode=‘V001’; SELECT odate,round(odate) FROM orderMaster WHERE vencode=‘V001’;


网友评论