On 8 Mar 2017, at 7:33pm, Rob Richardson <rdrichard...@rad-con.com> wrote:
> But the strftime() function is supposed to work with whatever format I give > it, isn't it? No. How could that work for a date like 3/4/2017 ? It wouldn’t know if that was the 3rd of April or the 4th of March. > According to the documentation, %d is a two-digit day, %m is a two-digit > month, and so on. Is there truly no way to convert my original string into > a datetime object? You can do it using substrings and concatenation, but there’s no simple way. And the text format you provided should not be stored in a database because it’s not sortable. The year must be first, then month, then day, etc. otherwise there’s no way to sort a column into date order without picking the various parts out and arranging them into a different order. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
