please stop crossposting.
msaka msaka wrote:
how works with time stamp in sqlite.. can you write here some examples (create time stamp field in integer or timestamp ??? and so on)
-----P?vodn? spr?va----- Od: Ken & Deb Allen [mailto:[EMAIL PROTECTED] Odoslan?: 22. apr?la 2005 21:02 Komu: sqlite-users@sqlite.org Predmet: Re: [sqlite] timestamp how to ?
Having used other databases extensively, and discovering that SQLITE does not have a native DATETIME data structure, I have elected to store the Date/Time value from the operating system (which is either a 32-bit or 64-bit value) directly into an INT field and then translate it into a string on retrieval.
I did some performance tests, and it seemed that converting a date/time string into the 32-bit or 64-bit value in my code and comparing integer values in a query were orders of magnitude faster than using the SQLITE functions for date/time comparisons on the fly. They are fine for formatting the data for display, but where I need to manipulate the data I still retrieve the 'raw' integer value and convert it as I require.
-ken
On 22-Apr-05, at 9:03 AM, [EMAIL PROTECTED] wrote:
"msaka msaka" <[EMAIL PROTECTED]> writes:
how can i use timestamp value in sqlite
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
