Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Location
    Bay Area
    Posts
    2

    Question Unanswered: Database reporting time differently than system

    Hiya,

    I have a database on a SQL Server 2000 (sp3a) installation. For some reason it's reporting time that is 7 hours ahead of the system time.

    The application is on one server the DB is on a shared production server. The app server and the DB server are reporting the same system time and are using a network time server. All the other db's on the shared production db server are reporting time correctly.

    My questions:

    Is there a T-SQL query to use to see what the time/timezone is for that database?
    Is there a T-SQL query I can use to set the db time (not the system time)?
    Anyone have any other suggestions as to what could be wrong?

    Thanks in advance for any help!
    'chele

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Is this from a select getdate() query in QA or the output of some app or stored proc? If app or stored proc, check for date manipulation. SQL Server picks up its time from the serer clock, there is no separate SQL Server clock.


    Unless it is using the getutcdate(), which is also derived from the system date / time / time zone setting.

    <QUOTE>
    GETUTCDATE

    Returns the datetime value representing the current UTC time (Universal Time Coordinate or Greenwich Mean Time). The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer on which SQL Server is running.

    Syntax

    GETUTCDATE()

    </QUOTE>

  3. #3
    Join Date
    Sep 2004
    Location
    Bay Area
    Posts
    2
    Thanks for the help.

    It's a canned app. Epolicy by McAfee, to be precise. I guess I will go to them for tech support now that I know it's probably not something I did.

Posting Permissions

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