Date and time data type in SQLite

I want to store timestamps in my SQLite database and this answer on this question was looking promising. Then, I saw the SQLite documentation which says that there are only 4 data types: TEXT, INTEGER, REAL, BLOB. How do I go about? Also, millisecond precision would be useful though I can manage if it only gives precision upto a second. Also, timezone isn't important.

Answers


Milliseconds or seconds since an epoch in an INTEGER. sqlite INTEGERs support up to 64 bits of storage.

Convert to/from string representations with timezone support in code.


SQLite does not have a separate storage class for storing dates and/or times, but SQLite is capable of storing dates and times as TEXT, REAL or INTEGER values.

1) TEXT - A date in a format like "YYYY-MM-DD HH:MM:SS.SSS".

2) REAL - The number of days since noon in Greenwich on November 24, 4714 B.C.

3) INTEGER - The number of seconds since 1970-01-01 00:00:00 UTC.

For more details you can visit TutorialsPoint SQLite


Need Your Help

css need to work without the font css

html css html5 css3 reactjs

i have a codepen where the react functionality works fine...

Map Reduce job on Amazon: argument for custom jar

amazon-s3 mapreduce

This is one of my first try with Map Reduce on AWS in its Management Console.