to_char( trunc(b.starttime/1000/60/60/24)+TO_DATE('1970-01-01 00:00:00', 'yyyy-MM-dd hh24:mi:ss'), 'yyyy-mm-dd') ||' ' ||lpad(mod(trunc(b.starttime/1000/60/60),24),2,'0') ||':' ||lpad(mod(trunc(b.starttime/1000/60),60),2,'0') ||':' ||lpad(mod(trunc(b.starttime/1000),60),2,'0') as cdate
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....