SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as System.TimeSpan, however if I create a list, the field is not implemented and shown. Is there a way to solve this issue?

share|improve this question
up vote 0 down vote accepted

You cannot do it. The BCS (External Lists) do not have this datatype implemented. Best way is to use it as a string. Later you can use jquery/code behind if binding to grid or any other control.

share|improve this answer
Thanks, I did that with a database view. The problem is that I have to write the data back which didn´t work. – AGuyCalledGerald Nov 9 '12 at 10:01

The data type System.TimeSpan is not supported by external lists.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.