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.
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