Do the math in sqlite:
SELECT date(’2010-01-27′,”+60 days”);
2010-03-28
And how many days will it be from today?
SELECT round(julianday(’2010-03-28′) – julianday(‘now’, ‘start of day’));
60.0 days
SQLite3 for Mac OS X (SQLite is preinstalled on every Mac)
source: appy geek
No comments:
Post a Comment