各位大侠:
我在oracle9i中通过select to_char(sysdate,'yyyymmddhh24misssss') from dual查询获得了毫秒的时间,但是我将其以字符串形式写进数据库后,用select to_date('20080613133654002','yyyymmddhh24misssss') from dual想将时间转换成毫秒却转换不了???哪位知道怎么能将字符'20080613133654002'转换成毫秒的时间,因为我这里要用两个时间相减,精确到毫秒!!!
谢谢!
我在oracle9i中通过select to_char(sysdate,'yyyymmddhh24misssss') from dual查询获得了毫秒的时间,但是我将其以字符串形式写进数据库后,用select to_date('20080613133654002','yyyymmddhh24misssss') from dual想将时间转换成毫秒却转换不了???哪位知道怎么能将字符'20080613133654002'转换成毫秒的时间,因为我这里要用两个时间相减,精确到毫秒!!!
谢谢!
结果
20080613134549548select to_date(to_char(sysdate,'yyyymmddhh24misssss'),'yyyymmddhh24misssss') from dual
结果
2008/6/13 13:46:43select to_char(to_date(to_char(sysdate,'yyyymmddhh24misssss'),'yyyymmddhh24misssss'),'yyyymmddhh24misssss') from dual
结果20080613134749650
- TO_DATE ('20080613134549548 ', 'yyyymmddhh24misssss')
)
* 1440
* 60
* 1000
FROM DUAL
结果
102000