On 2/1/2012 4:13 PM, Pawl wrote:
Can I eliminate this problem by using function strftime('%s',timestampevar)
Your strings are not in any format that strftime accepts. strftime('%s',
'15.01.2011') returns NULL.
You really, really should change the format of your timestamps. You
could do it in bulk, by running a statement like this:
update JX set edittime=substr(edittime, 7) || '-' || substr(edittime, 4,
2) || '-' || substr(edittime, 1, 2);
(a matching statement for JX_lim is left as an exercise for the reader).
Of course, you'd then need to update your software to read and write the
new format, going forward.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
