SQLite DATEDIFF ?
#1

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.
Reply
#2

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

******?
Reply
#3

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

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.
Reply
#5

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

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)