MikeW wrote:
>
> It's a string comparison, '2009/' is identical in each case
> but '1/7' > '01/20' since '1' > '0'
>   

i suspected it, ok.

> See also http://www.sqlite.org/lang_datefunc.html
>   
that page shows how to convert date in different formats: does that mean 
that i have first to convert the date
in a unix timestamp and then do a numercial comparison?

-- 

bye,
P.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to