Sorry if this is the wrong place for this. Just a quick comment that it would be good for the following documentation page about date functions to mention more specifically that the value of the fields need to be in one of the time formats:
http://www.sqlite.org/lang_datefunc.html The 'Time Strings' are mentioned in the page later on but I did not initially realize that the data storied in the field that I was trying to use strftime on needed to be in one of those formats. Maybe an example which shows data in a field would be good as well. All of the examples at the bottom are using direct values instead of values stored in the database columns. What is also confusing (and maybe is a feature request) is that the default JDBC format for the Xerial driver (at least) is to output a time as "2012-07-19 09:58:18.36" which doesn't [quite] match any of the internal formats. See this discussion: http://stackoverflow.com/a/11102689/179850 Thanks much for Sqlite!! ---------- This message was sent from a MailNull anti-spam account. You can get your free account and take control over your email by visiting the following URL. http://mailnull.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
