Hi,
You can use TO_DAYS() and FROM_DAYS() functions for what you need.
All details about Time and Date functions :
http://www.mysql.com/doc/en/Date_and_time_functions.html
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER
Permanent e-mail address :
gg@stripped
-----Original Message-----
From: Paul Hayer [mailto:PaulH@stripped]
Sent: Wednesday, 28 January, 2004 4:46 PM
To: 'mysql@stripped'
Subject: CALCULATING DATES
Hi,
I want to be able to show the total of the subtraction of the "returned
date" from the "from date" for each department for each month.
This to be done on a range of a year, and then when the next month comes
round for the calculation to take that month into account, so, shifting the
range to calculate by a month forward.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
