If your want to show time with date in your sql environment like, working with Sql Developer or Sql Plus or iSql Plus then change the value of NLS_DATE_FORMAT.
To change the value log in the sql environment and write:
alter session set NLS_DATE_FORMAT =’DD-MON-RRRR HH:MI:SS AM’;
then check the value…you are done..!!!
*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
well.
*********************************************************************************************************************