I am trying to get date testing and manipulation to work. Should this work:
select julianday('now') - julianday(startmonday) from wb
startmonday is a text field that contains 2009-03-30.
Also the following returns 'none'
select julianday(startmonday) from wb
Any help would be much appreciated
Kind Regards
Garry (Sqlite newbie)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
