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