If I use
SELECT ProductID,OrderDate ,DispatchDate, julianday(tblOrders.DispatchDate) - julianday(tblOrders.OrderDate) FROM tblOrders WHERE ProductID = 2195 AND OrderState IN (0,10) it work fine 1,(2195, u'2008-09-02', u'2008-09-12', 10.0) 2,(2195, u'2008-09-17', u'2008-09-29', 12.0) 3,(2195, u'2008-10-27', u'2008-11-12', 16.0) 4,(2195, u'2008-12-17', u'2008-12-24', 7.0) 5,(2195, u'2009-01-19', u'2009-02-04', 16.0) 6,(2195, u'2009-06-08', u'2009-06-12', 4.0) 7,(2195, u'2009-09-28', u'2009-10-02', 4.0) -- Giuseppe Non mi chiedermi di coniugarti i verbi non li so "se li avrei saputi mo' te l'imparavo" --------- Original Message -------- Da: [email protected] To: "[email protected]" <[email protected]> Oggetto: [sqlite] Difference between two dates fails Data: 20/11/09 16:14 Hi,why? SELECT ProductID,OrderDate ,DispatchDate, strftime('%d',tblOrders.DispatchDate) - strftime('%d',tblOrders.OrderDate) FROM tblOrders WHERE ProductID = 2195 AND OrderState IN (0,10) returns 1,(2195, u'2008-09-02', u'2008-09-12', 10) 2,(2195, u'2008-09-17', u'2008-09-29', 12) 3,(2195, u'2008-10-27', u'2008-11-12', -15) 4,(2195, u'2008-12-17', u'2008-12-24', 7) 5,(2195, u'2009-01-19', u'2009-02-04', -15) 6,(2195, u'2009-06-08', u'2009-06-12', 4) 7,(2195, u'2009-09-28', u'2009-10-02', -26) look at 3,5 and 7 row in 3 instead of 16 days it return -15 in 5 return -15 instead of 16 in 7 -26 instead of 4 it seems that when a date interval is between two months the function fails. any suggestion? -- Giuseppe Non mi chiedermi di coniugarti i verbi non li so "se li avrei saputi mo' te l'imparavo" -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it: http://www.email.it/f Sponsor: Gioca anche tu alla "faccia degli amici", crea la faccia che preferisci e vinci fantastici premi! Gioca ora Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=9868&d=20091120 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it: http://www.email.it/f Sponsor: Gioca e vinci subito con Danone Actimel. In palio 1.000 Euro ogni settimana! Gioca adesso Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=9873&d=20091120 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
