Tuesday, May 10, 2011

How to Show Time with Date in a Session ?

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..!!!

1 comment:

  1. 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 !!!!