I know there are now some time functions in sqlite, but I did not quite understand the
functions available in it. I apologise for the MySQL references below, but I wish to
achieve the query below with SQLite, assuming some of you are fimiliar with MySQL. Can
you help?
code----------------------------------------------------------------
SELECT TIME_TO_SEC(duration)as duration
FROM call_data where call_time <= '2003-12-04 16:41'
AND DATE_SUB('2003-12-04 16:41', INTERVAL duration HOUR_SECOND) <= call_time
-----------------------------------------------
Lloyd
