str<f>time is for formatting a standard format into whatever format you give it. You're thinking of str<p>time which would parse a given string based on your format. SQLite includes the format function, but not the parse one.
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Rob Richardson Sent: Wednesday, March 08, 2017 2:33 PM To: SQLite mailing list Subject: Re: [sqlite] Why isn't my time formatting working? But the strftime() function is supposed to work with whatever format I give it, isn't it? 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? RobR _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users