[Jefff]

I want difference between two dates, how to calculate days between 2012-04-06 and 2012-03-07 ? I have no idea how to do this.

[Calgon]

http://stackoverflow.com/questions/2...ates-in-sqlite

******?

[Jefff]

There is no other way to do this without julianday? like strftime ?

[Campbell-]

Quote:

Originally Posted by Jefff There is no other way to do this without julianday? like strftime ?

Well, the actually question you should answer is why you need it in another way and how that way should look like. I believe that there are several ways to handle this problem and the most common ways are shown above.

[Jefff]

In julianday returns 29.5464645645 and I want only 29, I know, I can select only 29 but this is another work

[Campbell-]

Quote:

Originally Posted by Jefff In julianday returns 29.5464645645 and I want only 29, I know, I can select only 29 but this is another work

https://sampwiki.blast.hk/wiki/Strfind

Search for the '.' and simply save the '29' in another variable. Then you're done.