Oracle Developer's Share

SQL、PL/SQL、Form、Report、Sysadmin、ERP、Error Log

2018-05-22

[SQL]取得時間毫秒

1596
0
sql

Oracle sql millisecond

SELECT TO_CHAR(SYSTIMESTAMP, 'yyyy-mm-dd hh24:mi:ssxff') time1, TO_CHAR(CURRENT_TIMESTAMP) time2 FROM DUAL;

sql

回首頁