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 represent time format AM/PM in Oracle SQL Plus

304942Jul 9 2002

How do we represent time format (AM/PM) using SQL plus ? I'd like to get 09/01/2002 12:00 AM or 09/01/2002 12:30 PM displayed. Your inputs will help.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2002

Added on Jul 9 2002

4 comments

86,372 views