Report Server Snapshot/History

• Warren Peace

  SSCertifiable

  Points: 5881

  More actions

  May 29, 2008 at 12:40 pm

  #207834

  I am trying to reverse engineer how Report server works. I am looking at some tables after creating a snapshot/history. On one table called ReportServer.dbo.History, there is a field called "SnapshotDate".

  This field is strange because the date value that is stored in it is always 7hrs off (late).

  I verified on the server and in SQL GetDate() that the date and times are correct.

  Does anyone know why this field is off by 7hrs? Is this by design? Where does it get the time from?

  Thanks

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  May 29, 2008 at 12:57 pm

  #821946

  I think it uses standard time UTC.

  Is your timezone a 7 hour offset (taking into account daylight savings if necessary)?