Timestamp format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 12

Thread: Timestamp format

Threaded View

  1. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Quote Originally Posted by RBARAER
    ALTER SESSION might match your needs for now, but it is a very bad habit IMO to rely on the session date format. I'm pretty sure you will regret it in the long term. So as a short-term solution that can be OK, but keep in mind that this should be changed in the future.
    I am not convinced, as I'm only making the change at the session level and not system wide level. Moreover, we do NOT use PL/SQL code but java, for the application.

    What are the pros & cons, if any, to support your opinion? What is the impact to performance? Is there anything else that matters, that I have overlooked?

    TIA.
    Last edited by ggnanaraj; 08-22-2006 at 08:36 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width