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
