Re: [sqlite] timestamp how to ?

2005-04-25 Thread Rene Tegel
lite-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) dire

Re: Re: [sqlite] timestamp how to ?

2005-04-25 Thread msaka msaka
redmet: 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-

Re: [sqlite] timestamp how to ?

2005-04-23 Thread Ken & Deb Allen
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

Re: [sqlite] timestamp how to ?

2005-04-22 Thread Derrell . Lipman
"msaka msaka" <[EMAIL PROTECTED]> writes: > how can i use timestamp value in sqlite http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions

[sqlite] timestamp how to ?

2005-04-22 Thread msaka msaka
hi how can i use timestamp value in sqlite i create table : create table sales (id integer not nul primary key, --- [this is time stamp information ??] bill_number integer, item_code integer, amount double); then i insert into sales: