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