Miguel wrote:
> Estimates,
> First of all, excuse my English, I recognise that it is not my strong.
> I need to do a query on a table and I return the difference in minutes
> between
> two times loaded in the table.
> Which would be the best way to make these differences.
> Since already thank you very much and greetings.
If you convert both dates to unixtime (seconds) and subtract you'll get
seconds between the two dates. Then divide by 60.
SELECT (strftime('%s','now') - strftime('%s','2004-01-01 02:34:56')) / 60;
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
