Sybase & System Time 
Author Message
 Sybase & System Time

Our Test environment normally requires that we set the system date
back to a time that corresponds to the data in the environment.  Typ-
ically, the data used in the test environment is from Production
dumps that are a few months old.  In order for the application to
function correctly, the SQL server must be able to perform getdate()
calls, etc, that return a date that closely matches the dates stored
in the database.

In the past, we have set the system time back to match the data.  While
this works fine for the application, we seem to experience some strange
O/S behaviour that our Systems people say might be related to the time
being set back.  While there is no hard proof that this is the case, we
would like to be able to prove, or disprove, the argument.

Is there some way to set the time of the server process to be other
than the system time?  I had hoped to find a global variable that
would define a delta offset for the server to apply to the system time.

Does anyone else have this type of issue?

TIA

Richard



Tue, 19 Sep 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Sybase System 10 & AT&T 3600

2. Time field for Sybase system 10

3. Sybase and System Time Question

4. Sybase as a real-time database system?

5. modifying system's date & time

6. Sybase Tech Notes && Sybase FAQ

7. VB4(16) & Sybase System 10 OpenRecordset problem

8. HELP!, Sybase System 11 & Delphi 1.x

9. Performance problems with Delphi & Sybase System 11

10. Performance problems with Delphi & Sybase System 11

11. SYSTEMS CONSULTS Needed @ SYBASE Inc, MA & TORONTO

12. Sybase System 11 Backup for AT&T Unix


 
Powered by phpBB® Forum Software