Gyurasits Zoltán <[EMAIL PROTECTED]> wrote on 07/27/2005 12:57:42 PM:
> > TIMESTAMP() is available as of MySQL 4.1.1. > > I can't use this version because replication working :( > > I use version 4.0.22 > > ----- Original Message ----- > From: "Martijn Tonies" <[EMAIL PROTECTED]> > To: "Gyurasits Zoltán" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> > Sent: Wednesday, July 27, 2005 6:31 PM > Subject: Re: Hour counts > > > > Hi, > > > > Check out the TIMEDIFF function. > > > > With regards, > > > > Martijn Tonies > > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL > > Server > > Upscene Productions > > http://www.upscene.com > > Database development questions? Check the forum! > > http://www.databasedevelopmentforum.com > > > > I would like to calculate the hour counts from 2 'datetime'. > > Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 hour > > > > I try this.... but not good! > > > > R1 : munkaido_end-munkaido_start /simple substract/ > > R2 : ROUND(ROUND((end-start)/10000)+ > > (((end-start)/1000-(ROUND((end-start)/10000)*10))/6),1) /good if is in > > one > > day/ > > R3 : ROUND((end-start)/10000)-76 /-76 because from 14. to 15. I don't > > understand/ > > > > > > start end R1 R2 R3 > > 07-14 15:00 07-14 17:30 23000 2.5 -74 > > 07-14 23:00 07-15 01:30 783000 78.5 2 > > 07-14 15:00 07-15 02:30 873000 87.5 11 > > 07-14 15:00 07-14 16:00 10000 1 -75 > > > > Please help me... (exist a function for this situation?) > > > > > > Tnx! > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > Then your next option is to convert your datetime values to "seconds since epoch" by using UNIX_TIMESTAMP() (see the same link everyone else has already given you for details). mysql>SELECT (unix_timestamp('2005-07-27 19:30:00') - unix_timestamp('2005-07-27 18:00:00'))/3600; +--------------------------------------------------------------------------------------+ | (unix_timestamp('2005-07-27 19:30:00') - unix_timestamp('2005-07-27 18:00:00'))/3600 | +--------------------------------------------------------------------------------------+ | 1.50 | +--------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) Shawn Green Database Administrator Unimin Corporation - Spruce Pine
