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
