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]