Function to extract only time from a date object?

Question

Trunc() funciton is to get date part without time from a date object. Is there any function to get Time part of the date object?

Answer 1

0

Use TO_CHAR(date,"<format>")

e.g.:

SELECT TO_CHAR(sysdate,"HH:MI:SS")

answered Dec 16 '09 at 02:28 PM

Andrew Mobbs
1.5k ● 1 ● 3

Thanks a lot Andrew! Now I am able to extract time. But I have question, don't we have a function like Trunc() to get time part? Here do we need to use TO_CHAR() ? Thanks once again.

Dec 16 '09 at 02:30 PM dbkid

Thank you Andrew.

Dec 16 '09 at 02:58 PM dbkid

Sorry - the stuff I wrote about TRUNC() and strings was rubbish... its been a long day. I meant of course TRUNC() and numbers.

Dec 16 '09 at 03:10 PM Andrew Mobbs

(comments are locked)

Answer 2

0

You can use extract() function also.

Function to extract only time from a date object?

Follow this question

Related Questions