I don't think the test programme arrived!
Anyway, I have found that using the SQLitte3 DATE function solves the
problem, so:-
AND DATE(TransDate) = '2009-07-01' produces the correct result.
Thanks
--
View this message in context:
I don't think the test programme arrived!
Anyway, I have found that using the SQLitte3 DATE function solves the
problem, so:-
AND DATE(TransDate) = '2009-07-01' produces the correct result.
Thanks
I'm thinking: contrary to other database systems, sqlite fields are not typed,
they can
Dear Benoît,
Please see attached - Ive not done this before, hope it works
Bill Lancaster http://old.nabble.com/file/p29760629/demo demo
http://old.nabble.com/file/p29760629/FMain.class FMain.class
--
View this message in context:
I want to extract records between 2 dates from a date type field (TransDate)
but using:-
hResult = FMain.$hConn.Find(transactions, TransDate = '2009-07-01')
produces the same result as
hResult = FMain.$hConn.Find(transactions, TransDate '2009-07-01').
Also sometimes records 1 day older than
I want to extract records between 2 dates from a date type field
(TransDate) but using:-
hResult = FMain.$hConn.Find(transactions, TransDate = '2009-07-01')
produces the same result as
hResult = FMain.$hConn.Find(transactions, TransDate '2009-07-01').
Also sometimes records 1 day older