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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
