System time sync with Oracle Server
-
Dear Friends, I m working on an aplication which is using Oracle as a backend. I need to sync the time between Oracle server and my machine using some oracle defined function. Actualy i m not very familiar with how Oracle supports for this time sync. Can anybody help me out with this? Thanks in Advance.. If u need any more input to answer please let me know Megha
-
Dear Friends, I m working on an aplication which is using Oracle as a backend. I need to sync the time between Oracle server and my machine using some oracle defined function. Actualy i m not very familiar with how Oracle supports for this time sync. Can anybody help me out with this? Thanks in Advance.. If u need any more input to answer please let me know Megha
I dunno about any built-in functions for Oracle (or any other DBMS for that matter), but if you cannot get the systems to sync to each other in the usual ways, your application can execute some SQL that returns the date/time on the server and you can sync the local PC's time to it. Not perfect, kludgly as hell, but when in a pinch... Peace!
-=- James
Please rate this message - let me know if I helped or not! * * *If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
See DeleteFXPFiles -
I dunno about any built-in functions for Oracle (or any other DBMS for that matter), but if you cannot get the systems to sync to each other in the usual ways, your application can execute some SQL that returns the date/time on the server and you can sync the local PC's time to it. Not perfect, kludgly as hell, but when in a pinch... Peace!
-=- James
Please rate this message - let me know if I helped or not! * * *If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
See DeleteFXPFilesThank you so much James. Could u plz tell me how can we set system time?
-
Thank you so much James. Could u plz tell me how can we set system time?
megha_gharote wrote:
set system time
SetSystemTime()[^] BTW, why don't you do a little Google search before asking a question? Just a suggestion. :)
A 'C++' question asked in the Visual C++ forum: Title: please stomuch me if i have string s[7]; s[1]="hello" ... s[7]="how are you" can i trace s[1] by loop and select specified item as example i, want to select e from s[1]="hello"..... the question is : this process possible or impossible!? I hope help me.......thanks - sofia_111
-
Dear Friends, I m working on an aplication which is using Oracle as a backend. I need to sync the time between Oracle server and my machine using some oracle defined function. Actualy i m not very familiar with how Oracle supports for this time sync. Can anybody help me out with this? Thanks in Advance.. If u need any more input to answer please let me know Megha