sharepoint-2010sql-server-2008-r2bcs
Timestamp in Sharepoint external content type not matching value in SQL table
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 server and they are fine. Any ideas what could cause this?
Solution
Check the normalisation settings for your BDC.
Make sure you set it like this:
<TypeDescriptor TypeName="System.DateTime"
Name="YourDate" DefaultDisplayName="Your Date">
<Interpretation>
<NormalizeDateTime LobDateTimeMode="Local" />
</Interpretation>
</TypeDescriptor>
- Data update error with SharePoint 2010 and MS Access 2010
- Why does SharePoint JavaScript define a function named “ULSTYE” and a label for an empty statement with the same name?
- can't display error messages with customErrors=Off in SharePoint 2010
- Workflow column not available when provisioning view against list
- Sharepoint 2010 SPListTemplate how to get list of fields?
- Get email administrators using wss 3.0
- How to get the Microsoft Template folder using C#
- Opening an Excel document from SharePoint using PowerShell
- Is the Server Collation Latin1_General_CI_AS_KS_WS required for Sharepoint 2010 Enterprise?
- Getting the displayName or loginName from SP.User in CSOM
- Downloading all Attachments to a SharePoint Item automatically
- Upload file to SharePoint Document library using powershell
- SharePoint CAML Query AND/OR operators
- Create SharePoint 2010 search content source that uses a BDC via PowerShell
- Sharepoint - How to update list from an Excel file
- SharePoint Farm Feature
- Create SharePoint 2010 ribbon button programmatically w/o feature XML
- EnsureUser not returning valid User
- SharePoint - Grant permissions for multiple users
- Sharepoint workflow deployed, but not showing up
- How do I validate the page title length in sharepoint 2010?
- Selected items on a sharepoint 2010 listitemcollection
- Auto Removal of files in Sharepoint Online
- Excel VBA code to upper case all cells
- Looking for search syntax documentation for SharePoint UserProfileManager.Search Method
- Sharepoint 2010 add a choice field
- CAML query to retrieve a list of users items with ids in a list
- How to programmatically create editable wiki pages within the Pages library of an Enterprise Wiki site
- SharePoint REST API: Not able to get list by getByTitle when list name contains spaces
- Sharepoint server not found from Sharepoint management shell