Re: [sqlite] Query Problem when Executed from PHP v5.2.9-2

Day as INT)=13 ORDER BY substr(eTimeStart,length(etimeStart),-2), CAST(aTIME as INTEGER)"; --- El mar 9-feb-10, Rush escribió: > De: Rush > Asunto: [sqlite] Query Problem when Executed from PHP v5.2.9-2 > Para: sqlite-users@sqlite.org > Fecha: martes, 9 de febrero de 2010,

[sqlite] Query Problem when Executed from PHP v5.2.9-2

I have a query that I can successfully execute from a Windows command prompt, and from the FireFox SQLite Manager (v0.5.9) SELECT CASE WHEN substr(substr(eTimeStart,1,2),-1) =':' THEN substr(eTimeStart,1,1)||substr(etimeStart,3,2) ELSE substr(eTimeStart,1,2)||substr(eTimeStart,4,2) END as aTIME FR