Extract time part from TimeStamp column in ORACLE

Question

Actually i' am using MyTimeStampField-TRUNC(MyTimeStampField) to extract the time part from an timestamp column in Oracle.

SELECT CURRENT_TIMESTAMP-TRUNC(CURRENT_TIMESTAMP) FROM DUAL

this return

+00 13:12:07.100729

this work ok for me, to extract the time part from an timestamp field, but i' m wondering if exist a better way (may be using an built-in function of ORACLE) to do this?

Thanks.

Answer 1

What about EXTRACT() ?

Answer 2

You could always do something like:

select TO_DATE(TO_CHAR(SYSDATE,'hh24:mi:ss'),'hh24:mi:ss') from dual

I believe this will work with timestamps as well.