I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values displayed in the Read List with the values returned when I query the DB in Management Studio. I've attached a picture with an example:
The times displayed in the browser are 4 hours earlier than the Time stamp returned by Management Studio. I've checked the Date and Time settings on both the client and all the servers and they are fine. Any ideas what could cause this?