t-master <t-zimmerm...@onlinehome.de> wrote:
> I have string in a table representing a DateTime.
> The format is 21.08.2009 00:25:00
I recommend you change the format. Yours is custom-designed to make your
life miserable.
> And I would like to compare it to "now"
select case when
substr(T, 7, 4)||'-'||substr(T, 4, 2)||'-'||substr(T,1,2)||substr(T,
11) > datetime('now')
then 'future' else 'past' end
from (select '21.08.2009 00:25:00' as T);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
