Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Time in CDR logs is off RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    This should be an easy one, Folks... my CDR logs are all off by 6 hours (we're GMT -6).  How do I correct this?

    Also, a select getdate() displays the correct time on the SQL server.
    AcroyearUSMC
    Wednesday, January 14, 2009 9:36 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    This behavior is by design.  It allows you to adjust for your local time zone when generating reports.

    Mike Stacy | Evangelyze Communications | http://www.evangelyze.net/cs/blogs/mike
    Wednesday, January 14, 2009 10:50 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, the time is stamped using GMT regardless of the server's location (hence the 6 hour offset when set to Central Time Zone.
    Jeff Schertz, PointBridge | MVP | MCITP: Enterprise Messaging | MCTS: OCS
    • Marked as answer by AcroyearUSMC Thursday, January 15, 2009 2:14 PM
    Thursday, January 15, 2009 2:02 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    This behavior is by design.  It allows you to adjust for your local time zone when generating reports.

    Mike Stacy | Evangelyze Communications | http://www.evangelyze.net/cs/blogs/mike
    Wednesday, January 14, 2009 10:50 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, the time is stamped using GMT regardless of the server's location (hence the 6 hour offset when set to Central Time Zone.
    Jeff Schertz, PointBridge | MVP | MCITP: Enterprise Messaging | MCTS: OCS
    • Marked as answer by AcroyearUSMC Thursday, January 15, 2009 2:14 PM
    Thursday, January 15, 2009 2:02 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Easy enough.  Thanks, Guys!  I'm sure that I'll ask about how to do some slick sql reports later... after I've played with the resource kit tools
    AcroyearUSMC
    Thursday, January 15, 2009 2:15 PM