How can I get datetime to display in wartime in oracle?

Question

I am running some queries to track the problem with our backup logs and would like to display datetime fields in 24 hour wartime. Is there an easy way to do this? I tried searching on the Internet and could not find anything.

Answer 1

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

Give time in 24 hour format.

Additional options are described here .

Answer 2

If you want all requests in your session to display full datetime, do

 alter session set NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS' 

at the beginning of the session.

Answer 3

Use to_char(field,'YYYYMMDD HH24MISS') .

A good list of date formats is available here.

Answer 4

This is not the oracle that defines the display of dates; it is a tool that you use to run queries. What do you use to show results? Then we can hope for the correct settings.