Bingo, Shawn wins the virtual beer(s). I never looked at the unix_timestamp function. Thanks to everyone else and wishing you virtual beers as well!
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters USA Central Time Zone 636-922-9158 ext. 8652 fax 636-447-4471 [EMAIL PROTECTED] www.nisc.cc ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, June 11, 2004 14:54 Subject: Re: Date/Time Difference Calculations > > I didn't see where these were 4.1+ function so I think it will work. I > refer you to: > http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html > http://dev.mysql.com/doc/mysql/en/Cast_Functions.html (if you ever run into > 'negative' time differences) > > SELECT sec_to_time(unix_timestamp(transfer_end) - > unix_timestamp(transfer_start)) from queue; > > I know it will work for values up to 24 hours different. If sec_to_time is > using an internal TIME data type value you get just under 840 hours of > differential. > > HTH, > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]