Hi All,
I am still not quite getting my head round the time functions. I have a MySQL
query which checks minutes within a period for a match for a match.
Can I achieve the same thing in sqlite?
MySQL code----------------------------------------------
SELECT TIME_TO_SEC(duration)as duration
FROM call_data where call_time <= '2003-12-04 13:10'
AND DATE_SUB('2003-12-04 13:10', INTERVAL duration HOUR_SECOND) <= call_time
----------------------------------------------------------------
Sorry to refer to MySQL code but it is all I have to go by.
