How can I get Datetime to display in military time in oracle?

oracle, sql

Solution

select to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') from dual;

Give the time in 24 hour format.

More options are described here.

Problem

I am running some queries to track down a problem with our backup logs and would like to display datetime fields in 24-hour military time. Is there a simple way to do this? I've tried googling and could find nothing.

Original source