摘要: Oracle 时间差计算两个Date类型字段:START_DATE,END_DATE,计算这两个日期的时间差(分别以天,小时,分钟,秒,毫秒):天:ROUND(TO_NUMBER(END_DATE - START_DATE))小时:ROUND(TO_NUMBER(END_DATE - START_DATE) * 24)分钟:ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60)秒:ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60 * 60)毫秒:ROUND(TO_NUMBER(END_DATE - ST 阅读全文
posted @ 2012-07-06 12:20 石 磊 阅读(4048) 评论(0) 推荐(0) 编辑