Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database

Another recent posting has suggested that there is a difference between the
times used by SharePoint itself and the times used in the database.

Hence the SharePoint web site shows the correct time but web parts (or in
your case Reporting Services reports) that obtain their data direct from
database records show incorrect timings.

Why is so far a mystery.

Mike Walsh
WSS FAQ: www.wssv3faq.com / wss.collutions.com
No private questions please (additions to FAQ welcome)

"RB0135" <robear@xxxxxxxxxxxxx> wrote in message
news:1166088575.422288.91460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have several Sharepoint Sites that are running fine, show the correct
date on the page, etc.

Recently, Iinstall SQL 2005 Reporting Services to create some reports
off the sharepoint databases for the Sites.

That's when I discovered that Sharepoint seem to be recording
information at GMT 0. I have setup the sites using the Central
Administration Web to GMT +10 (Sydney). I have also noticed that, as we
are in Summer Time, it is actually recording the date and time 11 hours
prior to the date, rather than the actual date and time.

Can I ask if anyone actually knows WHY does Sharepoint do this? Why
doesn't it record the correct Regional Date Time when the data was
written?

You can imagine that when you create a report that now I have to go
through a whole lot of date calculations just to get the right
date/time for the report (unless someone knows an easier way).

Any ideas?

Thanks,
Robert



.

Relevant Pages

  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... I think I wrote that the other report was of the *database* giving the wrong ... directly at the SQL 2005 database, ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... directly at the SQL 2005 database, ... Document List) must update the database directly with the GMT0 ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Reporting Services im Integrierten Sharepointmodus
    ... ich habe versucht einen Berichtsserver im integrierten Sharepointmodus ... Auf einem Windows Server 2003 SP2 Sharepoint Services 3.0 mit Add-In für ... Reporting Services installiert, SQL 2008 Reporting Services und BIDS. ... Berechtigungen auf die Berichte zu vergeben, ...
    (microsoft.public.de.sqlserver)
  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... I still pose the question as to why Sharepoint wants to write ALL ... I think I wrote that the other report was of the *database* giving the wrong ... directly at the SQL 2005 database, ... I have also done a test with the Reporting Services against the test ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: File deletion
    ... extensions (i.e. Microsoft Office). ... It's a product that specializes in SharePoint ... reporting information. ... > logfiles - and find the folder that has the logs for the portal. ...
    (microsoft.public.sharepoint.portalserver)