Re: [sqlite] Bind Question -- Is this correct?

On 3 Jul 2018, at 4:22pm, Stephen Chrzanowski 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

[sqlite] Bind Question -- Is this correct?

I'm attempting to do a simple bind for an integer. The partial query is: 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,