SELECT UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(your_column) / 60 AS Minutes FROM your_table
---John Holmes... > -----Original Message----- > From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 12:29 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Caculating minutes since DATETIME column? > > I need a way to calculate the number of minutes since the value of a > DATETIME column in mysql. Any ideas? Thanks. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
