select to_days('2003-11-10') - to_days('2003-11-19')
----- Original Message ----- From: "Fabio Bernardo" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, September 19, 2003 4:13 PM Subject: dates difference IŽd like to write a mysql statemant which takes two dates: for example:2003-11-10 & 2003-11-19 and results ...9 days something like :select 2003-11-19 - 2003-11-10 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]