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!

Convert 12 hours time format to 24 Hours time format

ADF-VictimSep 30 2015 — edited Sep 30 2015

Why does the following query not work?

Select To_date ('10:35 PM', 'HH24:MI') From DUAL

it gives the following error

date format picture ends before converting entire input string.

but the following query works fine

Select To_date ('10:35', 'HH24:MI') From DUAL

I need to convert the time format in the first query into HH24:MI in PLSQL, how can I do that?

Thank you

Thank youHH24:MI

This post has been answered by unknown-951199 on Sep 30 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2015

Added on Sep 30 2015

5 comments

10,801 views