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

Reply via email to