Thursday, 15 January 2015

What is the best way to save datetime type in SQLite? -


I am creating Android application and need to save the date / time of the construction record. What is the best way to do that? I have to compare it later. For example, in my app, I will show all the records that date A is created between Date A.

There is no specific date time type in SQLLay TEXT , You can use the real or INTEGER type, which is also tailored to your needs.

Directly from DOS

SQLite's repository is no different for archiving the dates and / or bars of the square, instead, the built-in date and time function of SQLite text, Real, or INTEGER values ​​are able to store date and time as:

  • Text as ISO8601 string ("YYYY-MM-DD HH: MM: SS.SSS") .
  • Actually as the number of Julian days, the number of days from November 24, 4714 BC in Greenwich. According to the cryptic Gregorian calendar,
  • number of seconds from INTEGER, 1970-01-01 00:00:00 UTC as Unix Time.

    The application can choose to store any date and time from these formats and convert them independently between the formats using the built-in date and time functions.

    SQLite can have built-in date and time functions.

No comments:

Post a Comment