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..!!!
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..!!!
Great blog. Thanks for putting your efforts in making such a helpful blog. You have shared so many interesting and helpful post that contain queries that are a great support to me. I have never thought that I can display date in a session but you do have suggested me a solution to this. Appreciating !!!!
ReplyDelete