SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to get a time part from Date datatype

715267Sep 27 2011 — edited Sep 30 2011

Hi,

I would like to know how to extract the timestamp alone from DATE datatype? If my input is '27-SEP-2011 23:59:00' I need the output as 23:59:00. I am surprised to see that there are no in-built functions for this or may be I am wrong. Basically I need to remove the date part from DATE data type and get the time.Please assist.

-Thanks

Edited by: user9546145 on Sep 27, 2011 2:24 PM

Edited by: user9546145 on Sep 27, 2011 2:25 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2011

Added on Sep 27 2011

4 comments

301,548 views