title: What is the preferred way to work with dates in Android SQLite and WHY?
body: <p>I'm aware that there is another <a href="https://stackoverflow.com/questions/7363112/best-way-to-work-with-dates-in-android-sqlite">similar question</a> on this topic, but personally I am not satisfied with the accepted answer, so this question also asks for an explanation to justify the preferred method. The accepted answer said that the "recommended practice to use a text field to store dates within SQL lite," but this does not make sense to me. I'm not knowledgeable enough to counter with a more definitive answer, but it is my understanding that strings use more memory and are more computationally more difficult to handle than integers. Would it not be better to use Unix timestamps (stored as integers), instead of text to store dates/time? Is not, what IS the downside to using Unix timestamps, compared to text?</p>