RE: CALCULATING DATES

2004-01-28 Thread Gelu Gogancea
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

RE: CALCULATING DATES

2004-01-28 Thread Gelu Gogancea
even if they have no entries( ie to show the dept and 0 as it's result)? Cheers. -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: 28 January 2004 15:08 To: Paul Hayer; [EMAIL PROTECTED] Subject: RE: CALCULATING DATES Hi, You can use TO_DAYS() and FROM_DAYS() functions