Oracle date计算
总结一个算时间差的sql,挺有意思的:
2008-01-21 12:14:03到2008-01-21 11:02:25差了有多长时间.
select sysdate,
trunc(to_date('2008-01-21 12:14:03','yyyy-mm-dd hh24:mi:ss') - to_date('2008-01-21 11:02:25','yyyy-mm-dd hh24:mi:ss'))
||' Day '||
to_char(to_date(trunc(((to_date('2008-01-21 12:14:03','yyyy-mm-dd hh24:mi:ss') - to_date('2008-01-21 11:02:25','yyyy-mm-dd hh24:mi:ss'))-trunc(to_date('2008-01-21 12:14:03','yyyy-mm-dd hh24:mi:ss') - to_date('2008-01-21 11:02:25','yyyy-mm-dd hh24:mi:ss')))*86400),'SSSSS'),
'fmhh24" Hour "mi" Minute "ss" seconds "') from dual;
2008-01-21 12:14:03到2008-01-21 11:02:25差了有多长时间.
select sysdate,
trunc(to_date('2008-01-21 12:14:03','yyyy-mm-dd hh24:mi:ss') - to_date('2008-01-21 11:02:25','yyyy-mm-dd hh24:mi:ss'))
||' Day '||
to_char(to_date(trunc(((to_date('2008-01-21 12:14:03','yyyy-mm-dd hh24:mi:ss') - to_date('2008-01-21 11:02:25','yyyy-mm-dd hh24:mi:ss'))-trunc(to_date('2008-01-21 12:14:03','yyyy-mm-dd hh24:mi:ss') - to_date('2008-01-21 11:02:25','yyyy-mm-dd hh24:mi:ss')))*86400),'SSSSS'),
'fmhh24" Hour "mi" Minute "ss" seconds "') from dual;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12361284/viewspace-154912/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
