Re: [sqlite] DATE_SUB

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 stil

[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 durati