mercredi 21 octobre 2015

sqlite datetime convert to .Net datetime

Xamarin SQLiteConnection cant' convert datetime value. Here is my query :

   var getDocumentsQuery = @"Select d.CreateDate
                                    From Document d
                                    Where d.IsSynced=0 ";

            var documents = _db.Query<DocumentDTO> (getDocumentsQuery);

DocumentDTO class has property

public DateTime CreateDate { get; set; }

where I execute query direct to sqlite database it returns such value:

2015-10-21 04:20:30

but from xamarin , in my documents every DocumentDTO object has default datetime value:

documents[0].CreateDate {1/1/0001 12:00:00 AM} System.DateTime

So, SQLConnection unable to convert datetime value correct

Aucun commentaire:

Enregistrer un commentaire