Skip to Main Content

SQL & PL/SQL

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
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
282,604 views