On 3/8/17, Rob Richardson <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
