Regional & Timezone Settings
Hey Guys,
Got a problem with time differences between my Sharepoint 2003 site and
my SQL content datase. Basically what is happening is the time created
for entries in my document libraries are showing correctly in
Sharepoint, but when i look at those same entries in the SQL Database
for sharepoint the time difference is +9:00, this is a pain for
reporting purposes. I've double checked all the regional settings for
the sites and the portal and they are set correctly / the same as the
Regional settings on the SQL server i.e WSS(Site Settings/Site
Administration/Change Regional Settings) and also SPS(Site
Settings/Central Administration/Configure Virtual Settings/{Virtual
Server}/General Settings . My question is, are there any other
locations the regional settings are set?
.
Relevant Pages
- Regional & Timezone settings
... Got a problem with time differences between my Sharepoint 2003 site and ... Sharepoint, but when i look at those same entries in the SQL Database ... Regional settings on the SQL server i.e WSS(Site Settings/Site ...
(microsoft.public.sharepoint.windowsservices) - Re: Regional & Timezone settings
... Is the SQL Server on a different server to the SharePoint installation and ... if so have you checked the time zone of the *server* on which SharePoint is ... running and compared that with the time zone of the server on which SQL ... Regional settings on the SQL server i.e WSS(Site Settings/Site ...
(microsoft.public.sharepoint.windowsservices) - Re: Regional & Timezone settings
... the SQL Server and Sharepoint server are on ... running and compared that with the time zone of the server on which SQL ... Regional settings on the SQL server i.e WSS(Site Settings/Site ...
(microsoft.public.sharepoint.windowsservices) - Re: Incorrect regional setting EVERYWHERE - reinstall?!
... You can re-install sharepoint and then re-attach your databases, ... then straight away you should check the regional settings in the portal ... However if your customized Site templates are all using the ... Level team sites to the correct timezone and your templates? ...
(microsoft.public.sharepoint.portalserver) - Re: Under what conditions will a query work on one machine but not
... Under Regional Settings, what differences are there? ... and typecast your calculated query fields ... post the SQL statement that yields different results. ... Allen Browne - Microsoft MVP. ...
(microsoft.public.access.queries) |
|
