>> 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
Try
SELECT round((julianday(duration)-julianday('00:00:00')) * 86400) as duration
FROM call_data where call_time <= '2003-12-04 16:41'
AND julianday('2003-12-04 16:41')-duration/86400.0 <= julianday(call_time)
I haven't tested it, but it's a start.
See also http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
