--------- Original Message --------
Da: "General Discussion of SQLite Database" <[email protected]>
To: "General Discussion of SQLite Database" <[email protected]>
Oggetto: Re: [sqlite] Difference between two dates fails
Data: 20/11/09 16:22
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
Thank you very much,
Even to Pavel.
>
> 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
--
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 con "faccia degli amici", in palio fantastici premi. Crea la
faccia che vuoi, adesso
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=9869&d=20091120
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
