2009/8/21 t-master <t-zimmerm...@onlinehome.de>: > Hi > I have string in a table representing a DateTime. > The format is 21.08.2009 00:25:00 > And I would like to compare it to "now" > How can I do this? > -- > View this message in context: > http://www.nabble.com/DateTime-comparison-with-custom-format-tp25085040p25085040.html > Sent from the SQLite mailing list archive at Nabble.com.
I recomend to convert dateformat to julianday() http://www.sqlite.org/lang_datefunc.html -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users