search

UbiCollab / UbiShare

Share ubiquitously!
1 stars 1 forks source link

Creation dates #13

Closed tcarlyle closed 11 years ago

tcarlyle commented 11 years ago

Currently several of the stored types have a CREATION_DATE field but in a string format. The problem of that is that we cant get the the query response to be ordered and we would even need to parse the string for doing some compassion. Can this be changed to a date format?

Just in case, it is important that this is set by the content provider or sync adapter

KatoStoelen commented 11 years ago

SQLite does not have a date datatype. My suggestion is to save timestamps in Unix time, and use INTEGER.

http://www.sqlite.org/datatype3.html#datetime

tcarlyle commented 11 years ago

sounds good!

BabakFarshchian commented 11 years ago

fixed- changed to integer. will use unix time.