DB/Oracle
milliseconds systimestamp
Edward. K
2008. 8. 26. 17:50
반응형
select
TO_CHAR(sysdate,'yyyymmddhh24miss') as d1,
TO_CHAR(systimestamp,'yyyymmddhh24miss') as d2,
TO_CHAR(systimestamp,'yyyymmddhh24missFF6') as d3
from dual
TO_CHAR(sysdate,'yyyymmddhh24miss') as d1,
TO_CHAR(systimestamp,'yyyymmddhh24miss') as d2,
TO_CHAR(systimestamp,'yyyymmddhh24missFF6') as d3
from dual
반응형