Hello! I have a table with times stored as strings. I massaged them into a form that strftime() should be able to work with, but it's not working. Here's a little query using the string as it is currently formatted:
select strftime('%d/%m/%Y %H:%M:%S', '03/07/2017 13:06:03') This query returns null. Why? (Hmmm... I see that it should return July 3rd, 2017 when I want March 7th, but that doesn't explain why it doesn't give me anything.) Thanks for your help. RobR _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users