Daily Archives: January 9, 2011
SQLite: Calculate difference between datetime fields
If you want to easily get elapsed time between datetime fields in SQLite you may want to take a look at following snippet: Table some_table contains 2 columns named start and finish both datetime type. Result will contain value in … Continue reading
Posted in actionscript, flash, SQLite3 (in AIR)
Tagged actionscript3, cast(), flash, select, SQLite, strftime
1 Comment