RE: Function to extract difference in Minutes from DateTime variables

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Function to extract difference in Minutes from DateTime variables

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Function to extract difference in Minutes from DateTime variables

2003-07-24 Thread Dathan Vance Pattishall
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 -->variable

Function to extract difference in Minutes from DateTime variables

2003-07-24 Thread C.F. Scheidecker Antunes
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.