Dominique Devienne wrote: > On Fri, Feb 10, 2017 at 6:53 PM, Stephen Chrzanowski <[email protected]> > wrote: >> The date and time are stored as a number, not >> "Friday, February 10, 2017 12:43:33pm". > > And that's exactly why SQLite has date and time functions. > Notably the one converting a number of seconds since the Epoch > into a human readable date time.
The date format shown above cannot be generated by SQLite. ISO8601 strings are human readable, but meant to be parsed by computers, and strftime() gives you only zero-padded fields for the same reason. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
