date show only hh:mm

enrique_aeo used Ask the Experts™
hi experts
i have this value in the database:
10/03/2017 02:25:45 a.m. the column type is date

I need only show hh:mm for example
09/03/2017 09:14:50 p.m.
show: 21:14

10/03/2017 02:25:45 a.m.
show: 02:25
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
select to_char(date_column,'HH24:MI') from some_table;
johnsoneSenior Oracle DBA

I believe this goes along with your other question.  What displays is a function of NLS_DATE_FORMAT and the TO_CHAR function.  If you do not supply a format to TO_CHAR it defaults to NLS_DATE_FORMAT.

TO_CHAR(col, 'hh24:mi')

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial