Home > Tech.Notes > Oracle计算时间差的方法

Oracle计算时间差的方法

Oracle计算时间差的方法。总结了一下:
天:
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 - START_DATE) * 24 * 60 * 60 * 60)

–EOF–

Categories: Tech.Notes Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Additional comments powered by BackType