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!

TO_CHAR(DATE) doesn't show minute's leading zero when using fmMonth

Andy SteelFeb 1 2013 — edited Feb 4 2013

When using fmMonth as part of the picture to display a date & time, the leading zero of the minute is not shown.

For example, assuming that the current time is 10:04:01

select to_char(sysdate, 'fmDay, fmDD fmMonth, YYYY HH24:MI:SS') from dual;

Friday, 01 February, 2013 10:4:01

select to_char(sysdate, 'fmDay, fmDD YYYY HH24:MI:SS') from dual;

Friday, 01 2013 10:04:01

So as soon as I include fmMonth, the formatting of the minute aspect is lost. Any ideas ?

Oracle Release 11.1.0.6.0

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2013

Added on Feb 1 2013

6 comments

7,609 views