If the data type is timestamp then as per the KB it should display the date till mili second. Is that not correct? Why to format a timestamp field again?
TIMESTAMP - denodo
Timestamp without a time zone (year, month, day, hour, minute, second and fraction of second with nanosecond precision)