Oracle 取微秒 - 记录点滴

Posted on 2017-09-23 Edited on 2025-07-25 In Tech Symbols count in article: 188 Reading time ≈ 1 mins.

昨天在群里看到有人问怎么通过sql在oracle中取微秒

以前没有遇到过，就搜索了一下，找了一会给找到了

1	select to_char(systimestamp, 'yyyy-mm-dd hh24:mi:ss ff') from dual;

输出:年-月-日时:分:秒微秒

1	2017-9-24 10:38:27 129368

很少问题是搜索引擎找不到的，学会如何描述问题才是关键

Post author: hisenyuan
Post link: http://hisen.me/20170923-Oracle-取微秒-记录点滴/
Copyright Notice: All articles in this blog are licensed under BY-NC-SA unless stating additionally.