- SQL:> select numtodsinterval(365, 'second') from dual;
- 结果:+000000000 00:06:05.000000000;
- SQL:> select SUBSTR(numtodsinterval(365, 'second'),12,8) from dual;
- 结果:00:06:05;
- SQL:> select to_char(to_date('1000 ', 'sssss '), 'hh24:mi:ss ') from dual;
- 结果:00:16:40 ;
- SQL:>select trunc(30682/3600) || '小时' || to_char(to_date(mod(30682,3600),'sssss'),'fmmi"分"ss"秒"') from dual;
- 结果:8小时31分22秒;
- //注意:以上转换的都只能是在24小时以内
- SQL:>select trunc(3601*24/3600/24) || '天' || to_char(to_date(mod(3601*24,3600*24),'sssss'),'fmhh24"小时"mi"分"ss"秒"') from dual;
- 结果:1天0小时0分24秒;
- http://yangtao880705.blog.163.com/blog/static/1225083442012112511365183/
Oracle将number类型的时间值转换成时间格式的字符串
最新推荐文章于 2023-07-14 16:45:47 发布