Please ignore this question. I have already work it out ages ago, but had
forgotten.
----- Original Message -----
From: "Lloyd thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 03, 2004 12:59 PM
Subject: [sqlite] DATE_SUB
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
