search

TimotheeJeannin / ProviGen

Easily make a ContentProvider from an annotated ContractClass.
MIT License
243 stars 27 forks source link

datetime type? #34

Closed ghost closed 10 years ago

ghost commented 10 years ago

how can I declear datetime type column?

TimotheeJeannin commented 10 years ago

Hi @nambv,

As stated by the SQLite documentation on datatypes: 

SQLite does not have a storage class set aside for storing dates and/or times. 
Instead, the built-in Date And Time Functions of SQLite are capable of storing dates 
and times as TEXT, REAL, or INTEGER values:

* TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS").
* REAL as Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C. according to the proleptic Gregorian calendar.
* INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC.

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.

As there is no DATE datatype in SQLite, there isn't any in ProviGen either. You just need to decide how you want your dates stored using either INTEGER, REAL or TEXT.