On 3/8/17, Rob Richardson <rdrichard...@rad-con.com> wrote: > 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')
SQLite uses ISO-8601 dates: YYYY-MM-DD -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users