SQL Developer is returning only the date, not the time. How do I fix this?

date datetime time oracle-sqldeveloper

Xonatron · Sep 27, 2012 · Viewed 242.1k times · Source

Here's what SQL Develoepr is giving me, both in the results window and when I export:

CREATION_TIME       
------------------- 
27-SEP-12
27-SEP-12
27-SEP-12

Here's what another piece of software running the same query/db gives:

CREATION_TIME       
------------------- 
2012-09-27 14:44:46 
2012-09-27 14:44:27 
2012-09-27 14:43:53

How do I get SQL Developer to return the time too?

Partial answer:

select TO_CHAR(creation_time,'DD-Mon-YYYY HH24:MI:SS') from

If anyone knows how to set the default to show the full information, please answer below.

Answer

Can you try this?

Go to Tools> Preferences > Database > NLS and set the Date Format as MM/DD/YYYY HH24:MI:SS