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!

How to get 24hr time format

413708Apr 13 2004 — edited Oct 24 2005

I have a question which is when I use to_char(sysdate,'hhmi') to get today's time, I find that it retuns me 330 when the time is 3:30 pm.

My question is how to get 1530 when the time is 3:30 pm?

Thank you for reply.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2005

Added on Apr 13 2004

9 comments

770 views