On Nov 20, 2009, at 11:15 PM, [email protected] wrote: > Hi,why? > > > SELECT ProductID,OrderDate ,DispatchDate, > strftime('%d',tblOrders.DispatchDate) - > strftime('%d',tblOrders.OrderDate)
Maybe %J instead of %d. %d is the day of the month. %J is the julian day. http://www.sqlite.org/lang_datefunc.html > > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
