Skip to Main Content

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

Comments

454916
Oracle has announced desupport for Oracle 9i release 2 as of July 31, 2007 (see Metalink note 161818.1)
44863
If you have metalink access.
https://metalink.oracle.com/metalink/plsql/f?p=140:12:8247518256442992494::NO

rgds
454916
more info in previous thread:

1819921
h_kanchan
Thanks a lot guys , you have been a real help

Cheers
alanm
If you upgrade to 9.2.0.8 you will get an extra year support.


rgds

Alan
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 28 2011
Added on Sep 27 2011
4 comments
300,640 views