Use UNIX_TIMESTAMP or TIME_TO_SEC -->-----Original Message----- -->From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED] -->Sent: Thursday, July 24, 2003 1:43 PM -->Cc: 'MySQL Users' -->Subject: Function to extract difference in Minutes from DateTime -->variables --> -->Hello all, --> -->I need to compare a datetime field in my database with the current time -->and return only the records that are 5 minutes old or older. Is there -->any way to do it? Any function to it? --> -->I use to_days() when I am doing the same thing but with days instead of -->minutes. --> -->Thanks in advance. --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]