Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Unanswered: time stamp on remote systems?

    hi i am a noob here....and not a db dude
    but i work at a company that uses oracle for everything....but our main db is in another state...pacific time....and we are in central....but all our systems here reflect pacific time stamps and current pacific time for our application....i checked the help and are running app 11.5.10.2 and rdbms 10.2.0.4.0 if it helps?.....

    so my question: is it possible for us to do something so that on our local systems it will show us our central time while still maintaining the pacific time stamp on the main db elsewhere? and when we pull up files from the database it converts that pacific stamp to our central? or is this too much to ask?

    thanks for any help
    and if it is possible i will probly start researching so i can just tell them how to instead of them trying to figure it out

  2. #2
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    ther are may time conversion function available in oracle you can use any one of these
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

Posting Permissions

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