I wana share another finding of BCS SharePoint 2010.
I had few DateTime type fields for my External Content Type, I was developing through VS 2010 to bring the sql data using a sql view. All was working well but when i saw data in external list for these fields the time was coming 5:30 mins more than the actual time (:0 Strange right ! )
like if my actual date is : 2010-12-30 17:31:53.000
DateTime in External List was coming as : 12/30/2010 11:01 PM
After googling for some time I found one article which says BCS WebPart does not understand DateTime. (BCS WebParts are used to show external list data)
So, its alternative I found was to bring the DateTime field data as string into the External List. Which worked well for me.
Happy SharePointing 🙂