External list not implementing TimeSpan field

Question

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?

Answer 1

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.

Answer 2

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