[dba-SQLServer] UTC Date Time Fields and Baan with SqlServer

Stuart,

I wanted to try your method to at least retrieve the settings.
I ran the Query analyzer and ran 

Exec sp_help_targetserver  

And the return message was that it "could not find stored procedure
sp_help_targetserver".  I was it running against the specific database. 

I then ran it against all the databases and it only found it in msbd.

I copied the SP from msbd to the database I'm working with and it now
returned some column headings but no data.

Am I missing something?



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Tuesday, August 08, 2006 6:13 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] UTC Date Time Fields and Baan with SqlServer

On 8 Aug 2006 at 17:52, askolits at ot.com wrote:
> 
> For some reason, when we look at the data through SqlServer. All the times
> are 4 hours off. When we use their app, the time is correct.
> 
> The question is, is it their app or a setting we need to set in SqlServer.
> The claim it's not there issue and they don't support direct access to the
> data through SQL Server. 
.....
> 
> Note: They used to use standard time fields but now using UTC (makes
sense?)

And your time zone is -0400, so ISTM that it is working exactly as it 
should.  

If you want local times in your reports,  you will have to add your time 
zone offset to the stored times.  

You can use sp_help_targetserver  to return  time_zone_adjustment for you 
server.




-- 
Stuart


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com