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

We're talking about the same thing.

I think I wrote that the other report was of the *database* giving the wrong
time.

I made what was obviously the wrong assumption that you were accessing
reporting services via a web part.

Sorry for the confusion. It's the same issue that was reported earlier.

Mike Walsh

"RB0135" <robear@xxxxxxxxxxxxx> wrote in message
news:1166094614.709790.95370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Mike..

Thanks for your reply, but I should clarify one thing.

When I mentioned about seeing the Date/Time at GMT0, I was looking
directly at the SQL 2005 database, through the SQL Server Management
Studio which means that the standad Sharepoint Lists (such as a
Document List) must update the database directly with the GMT0
Time/Date.

I have done a test by updating the database directy (using the New
Query Option) under SSMS and it created a record with the correct
Date/Time I specified, ruling out any transformation from SQL

I have also done a test with the Reporting Services against the test
record and it returns the exact Date/Time in the database, again, with
no transformation...

Hope the extra info might provide some assistance in discovering why.

Robert


Mike Walsh wrote:
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
    ... 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: MS ACCESS for MAC
    ... SQL is pretty much SQL no matter what application you use. ... relational database - there's really nothing to debate. ... I've had very little to do with FileMaker: In reporting, ...
    (microsoft.public.mac.office)
  • RE: Auditing users added to WSS Sites
    ... SharePoint Report Pack for Microsoft SQL Server Reporting Services. ... level reporting by far, but it too adds triggers to the SharePoint tables. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: 3vl 2vl and NULL
    ... reporting, MV end-users were either churning out reports and ad hoc ... MV-database-independent applications as often as they do in the SQL ... where I cannot leave MV behind unless I can find a better data model. ... screen to be identical to the logical data model of the database. ...
    (comp.databases.theory)
  • Re: Delphi Roadmap (by David I)
    ... which can be done on the server on the server, ... and this is part of the reason that people buy the reporting ... which would be a bit like saying an SQL ... > parser is a database ...
    (borland.public.delphi.non-technical)