I have just created list and in that list I create a datetime field, and I developed a C# program to get the list data, but when my program get datetime field value, have a wrong, in my sharepoint list, the datetime value is 2017/4/14 00:00, but in my program, the value is 2017/4/13 5:00 PM. I've searched on google so many times but have no result. Do anyone know about this problem? Please explain for me. Thanks!
I spent a few days to find out the problem. Finally, I understanded the mechanism of saving datetime in SQL Server of Sharepoint: Sharepoint used the UTC timezone to store datetime value in Sql server (whatever your timezone is). Althought my timezone is UTC+7, but in SQL sever is UTC, so when C# client code access sql server to get data, it got the datetime value in UTC timezone.