oracle hh24 mi ss.ff,How to convert date to timestamp(DD-MON-YYYY HH24:MI:SS.FF format) in oracle?

I tried below query but its not working

select

TO_TIMESTAMP(ColumnName(Data type Date), 'DD-MON-YYYYHH24:MI:SS.FF')

from TableName

where Changedate>='01-Dec-2015'

*I need the result without AM/PM indication.

Result will be 15-DEC-2015 15:16:42.045016

# Answer 1

If I got your question right you need the output in the mentioned Format. That would be a conversion to character

select to_char(cast(sysdate as timestamp),'DD-MON-YYYY HH24:MI:SS.FF') from dual

Of course in the above the FF would also always be 000000

But if you have a timestamp variable you would not cast

select to_char(systimestamp,'DD-MON-YYYY HH24:MI:SS.FF') from dual

# Answer 2

select to_char(cast(sysdate as timestamp),'DD-MON-YYYY HH24:MI:SS') from dual

# Answer 3

I think you need not have to convert to timestamp if your column is of date data type. Also there is no need to use .FF as date will not have time in milliseconds.

select to_char(ColumnName(Data type Date), 'DD-MON-YYYYHH24:MI:SS.FF') from dual;

# Answer 4

These are 2 ways you can try:

to_char(cast(sysdate as timestamp), 'YYYY-MM-DD HH:MM:SS.ff')

or:

to_char(to_Date(sysdate, 'DD-MON-YY'), 'YYYY-MM-DD HH:MM:SS')