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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
