Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select date with time including milliseconds from edit_sysdate in oracle 19c

User_CSOQUDec 29 2019 — edited Dec 29 2019

I want to select date with time including milliseconds from edit_sysdate.

Query 1: is works fine.

select EDIT_SYSDATE,TO_CHAR(EDIT_SYSDATE,'DD-MON-RRRR HH24:MI:SS') EDIT_SYSDATE_Milisecond  from EMPLOYEE a WHERE  Employee_id = '0002';

Output:

EDIT_SYSDATE           EDIT_SYSDATE_MILISECOND     

-----------------                -----------------------------

28-DEC-19                   28-DEC-2019 18:35:01

My Query is: it is not working

select EDIT_SYSDATE,TO_CHAR(EDIT_SYSDATE,'DD-MON-RRRR HH24:MI:SSxFF3') EDIT_SYSDATE_Milisecond  from EMPLOYEE a WHERE  Employee_id = '0002';

My Expected Output is:

EDIT_SYSDATE           EDIT_SYSDATE_MILISECOND     

-----------------                -----------------------------

28-DEC-19                   28-DEC-2019 18:35:01:124

Please help.

This post has been answered by Gaz in Oz on Dec 29 2019
Jump to Answer
Comments
Post Details
Added on Dec 29 2019
4 comments
55,370 views