[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