On Nov 22, 2011, at 6:44 PM, Pavel Ivanov wrote: >> INSERT INTO [filed1] VALUES TIME('29-01-2011 08:00:00') > > Result of TIME('29-01-2011 08:00:00') is NULL. So your field1 doesn't > contain anything. Maybe that's why your comparison doesn't work.
As per the fine manual: http://www.sqlite.org/lang_datefunc.html Try YYYY-MM-DD HH:MM:SS instead. So: sqlite> select time( '2011-01-29 08:00:00' ); 08:00:00 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users