Hello,
To search and sort the dates in SQLite,
the SQL methods (strftime and date) are they fast enough on long dates (as
'2012-12-07 01:48:45')?
Or would you prefer to store separately the day, year, etc..?
example:
select invoice.date from invoice where strftime('%m', invoice.date)='02' and
strftime('%w', invoice.date)='1'
For invoices made on a Monday in February.
From your experience, these requests are they fast?
Thank you,
olivier
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
