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 show timestamps in 24h style?

pstein-JavaNetAug 4 2009 — edited Aug 4 2009

When I enter in SQLplus some SELECT statements with a column which contains a timestamp then the output
is currently in 12h format (with AM/PM indicator).

How do I tell Oracle SQLplus to output all timestamp values from now on in 24h style?
Peter

This post has been answered by John Spencer on Aug 4 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 1 2009

Added on Aug 4 2009

6 comments

9,201 views