Same SQL DateTime column value display differently in sharepoint  2013 External List

Using SharePoint Designer 2013, I created some ECT's and for each ECT I am creating External List without modifying them using InfoPath or other means..

I am using SQL DB as Data source for ECT..

I am facing a weird issue.

I am storing datetime value in SQL database table column with SQL datatype 'DateTime'.

Image 1:- Column data in Database table

Same value when displayed on External List 'List' displays in current Timezone format. For me this zone is GMT + 5.5 hrs.  So I see the time as local time and I am HAPPY to see auto formatting.

External List 'List View' with local time ( GMT + 5.5 hrs)

Another External List has Foreign key relation with first table, so while Creating New record on 'New Form' I do see the External List item selection control..

External List Item Selection control for Forgein Key relationship column

When I open the corresponding item selection box, I do see the record:

Time as stored in database table column

I do see the time exactly the same as stored in DB, and since this is again a UI for me this time is not in current Timezone and so a confusion for the end user. Same column value on UI displaying different result... and this is my Query. How do I resolve this.


September 4th, 2015 6:08pm

Hi,

I suggest you can set LobDateTime Mode to Local and test again.

The date and time in my external content type, BDC/BCS list are incorrect (off by x hours)

Hope this will help you.

Best Regards

Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 3:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics