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!

What is the difference between HH and HH12 in date time formats?

Eslam_ElbyalyMar 30 2022

Hi, I am using Oracle datebase 18c XE. Is there any difference between HH and HH12 date time formats? for example, when using...
to_char(sysdate, 'dd-mm-yyyy hh:mi') from dual
vs
to_char(sysdate, 'dd-mm-yyyy hh12:mi') from dual

This post has been answered by Anton Scheffer on Mar 30 2022
Jump to Answer
Comments
Post Details
Added on Mar 30 2022
9 comments
3,960 views