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

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: 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)
  • Steps for Migrating WSS 3.0 from Windows Internal Database to Microsoft SQL 2005
    ... done the stupid things I did when I started playing with Sharepoint ... when I first installed it and assuming that it would find the SQL 2005 ... Windows Internal Database). ... Reboot the server to finish up any uninstall scripts. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Configuring Full Text Search FOr SharePoint Web
    ... My SharePoint database had been upgraded to SQL and the data was being ... You need to make sure that you have upgrade your sharepoint instance to ...
    (microsoft.public.windows.server.sbs)
  • Re: Question about forms and data storage
    ... app that synchs the data from SQL to a list, ... or look at moving the core data into the sharepoint ... list over the database... ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: HELP HELP!! PLEASE - Company web issue
    ... All I know is that when I installed SQL as an "after the fact" process, ... gave me the option to convert my sharepoint. ... > We're starting to get beyond my level of experience with SQL and SBS. ... >>> You receive a "Cannot connect to configuration database" error message ...
    (microsoft.public.windows.server.sbs)