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:
insert into sales (id,bill_number,item_code,amount) values
(21052005121300,1,84545,251.50);
insert into sales (id,bill_number,item_code,amount) values
(21052005121301,2,84566,511.50);
....
insert into sales (id,bill_number,item_code,amount) values (xxxx,xx,xx,xxxx);
where timestamp 21052005121300 is 21.05.2005 / 12:13:00 it is good or sqlite
has its own timestamp
representation?
is goog to use timestamp to create statistict on this sale table for example
select sum(amount) where id between xxxxxxx and xxxxxxx; ?
will be this statistics slower and slower when table will have over 1 000 000
records ?
(i only create statistict on 1000-2000 records on this milion table)
thanx fo answer
