On 20 Mar 2014, at 2:19pm, Stefano Ravagni <stefanorava...@gmail.com> wrote:
> I know, in facts i use a TEXT field...so you intend datagrid usually > understand if the field is or not a DATE field showing the value in > auto-formatted way ? SQLite does not have a DATE datatype and does not understand dates at all. You will need to store your dates as text or numbers, and use text and numbers when testing and comparing it. If storing your data as text (slow but human-readable and ready for display) you should use standard form. If storing your data as numbers (faster but harder to debug) I would suggest Julian day numbers. SQLite does provide some functions that will help with this: <http://sqlite.org/lang_datefunc.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users