Hi, I have a requirement. Everytime when i make a session to the database i want the Date Format to beas follows 'yyyy-mm-dd hh:mi:ss' The existing default format is 'dd-mon-yyyy' and so I tried the following steps. ALTER SESSION set NLS_DATE_FORMAT='yyyy-mm-dd hh:mi:ss' and put that in the login.sql it worked fine for my every client session. How can I set it globally so that everytime when I make a session to database from any client It should be 'yyyy-mm-dd hh:mi:ss'. Regards Sundar