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!

Date Conversion AM/PM to 24Hours

santhosh TNov 8 2021

Hi All,

Please help me in converting this DateTime value to 24hours format.

SQL> SELECT TO_CHAR('08-NOV-2021 10:00 AM') "DATE" FROM DUAL;

Thank You

This post has been answered by Solomon Yakobson on Nov 8 2021
Jump to Answer
Comments
Post Details
Added on Nov 8 2021
5 comments
17,223 views