On 3 Jul 2018, at 4:22pm, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> V1: *datetime(date(current_timestamp,'localtime'),'+'||:StartTime||' > hours')))/60) MinutesSince9* > V2: *datetime(date(current_timestamp,'localtime'),'+:StartTime > hours')))/60) MinutesSince9 * > > I'm getting a failure with V2, and I'm assuming that binding isn't > understood when the bind is within a string. If this assumption is > correct, is V1 the correct and safe way to bind the values? Yes and yes. SQLite does not scan strings to look for binding tokens. But it does consider a binding token anywhere it might find a column identifier. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users