Date and Time Datatypes in SQLite
What are the various formats in which Date and Time Datatype can be stored in SQLite 3. How each is calculated by a System
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Oct 19, 2011, 12:33 AM
SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functionsof SQLite are capable of storing dates and times as TEXT, REAL, or INTEGER values:
Applications can chose to store dates and times in any of these formats and freely convert between formats using the built-in date and time functions.
Thanks,
Pravin.
Prabhu RajaPosted Oct 19, 2011, 4:21 AM
http://www.sqlite.org/datatype3.html