Report Server Snapshot/History

  • 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

  • I think it uses standard time UTC.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply