Those who use the Oracle SQL Developer for running the queries will face the problem of displaying the time. When you run a select statement for a table which has the data and time column, the result would show only the date and not the time. By setting the alter statement for the session you use, you can see the date and time values. This alter statement has to be set for each sessions.
Display or show the date and time values
alter session set nls_date_format = ‘DD-MON-YYYY HH24:MI:SS’