Is there a way to only extract HOUR,MINUTES and Seconds from timestamp.. Along with date ofc but i dont want it to show fractional\_seconds\_precision with it.. So for example when I type the following:

```
TO_TIMESTAMP('2017-12-02 05:00:00', 'YYYY-MM-DD HH24:MI:SS')

```

I only want what i specified in the format to be shown, I dont want FF to be shown but whenever I check the output, FF always comes along with it. How do I remove it? Also, I wanted to ask, Is there a way to compare the dates typed using timestamp to be compared with dates typed using TO\_DATE? what if I want one to be timestamp and other to be in a TO\_DATE format? Thanks