Link to home
Start Free TrialLog in
Avatar of enrique_aeo
enrique_aeo

asked on

date show only hh:mm

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
--1
09/03/2017 09:14:50 p.m.
show: 21:14

--2
10/03/2017 02:25:45 a.m.
show: 02:25
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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')